Queries

Calender to switch to the month
One of the control on the form is FldMon. It is a number field. There is a calender on the form. It is ActiveX Control: Calender0 Class is MSCAL.Calender.7 I am using Access 2003 and the tables are Access 2000 format Now when the user updates the field FldMon with a number (1 to 12) I want the calende... 25 Apr 2010 20:06

Removing Certain Records from a Query and Report
Hello, I am using Access for a university assignment. I created a query to find the most expensive items from my table. I have sorted the query results in descending order by cost. For the assignment, the Report is supposed to show only the top five most expensive items. How do I delete all the other items... 25 Apr 2010 17:51

Access Queries
I need to perform a query that will show me all of the items that were posted between two separate dates,such as 05/26/2009 - 10/24/2009. Can anyone please offer a bit of help. Thanks a lot. ... 25 Apr 2010 16:44

Custom Function
I am trying to create a tool for yearly employee performance reviews: each employee is ranked on 5-10 different "competencies" and their behavior related to those competencies throughout the year. I have a table tracking those events. At year end I would like to create a report bound to a query that groups th... 25 Apr 2010 23:24

Duplicate a record
Hello, Is there an easy way to duplicate a record in a continuous form? More yet, how would you write a query to duplicate the current record based. I would suppose some time of Append Query right? If so how would you write it? Please describe steps in an easy way to understand. Thanks! Iram ... 24 Apr 2010 20:33

Query or Table Description
all my database are developed in Access 2003... When viewing the queries in 2003 there is a 'Description' field. This is always viewable for all queries AND is sortable. I use this field to put my queries sequence... This is how I know the sequence of queries to run - I sort this field. I also use this field... 24 Apr 2010 19:27

Viewing expressions in a listbox
Access 2003, XP pro, semi-novice I have a table "Expression" where records are similar to the one below: [Adjective] & " " & [vehicle] & " is " & [color] [Adjective] & " " & [color] & " " & [vehicle] & " has a puncture" [Adjective] & " " & [vehicle] & " has a " & [color] & " stripe" I have another table "Wor... 24 Apr 2010 15:02

Surprisingly fidly query?
Hello All I'm sure this should be simple - but can't seem to get it! I need a query that takes various integer values (say 'monthnumber'), and returns an integer (say 'period') between 1 and 12, according to the following pattern: 'monthnumber' 1 returns 'period' 1 'monthnumber' 2 returns 'period' 2 'mon... 24 Apr 2010 18:21

Min Funtion
My query is based on one table listing employee names, ids, and salary. In my query I used the min funtion to display the lowest salary; however, I'm not able to display the employees name with the lowest salary. Your help is appreciated. -- CK ... 24 Apr 2010 12:48

Printing crosstab query
Dear All, I would like to print a cross tab query directly.I need to change the date and title of it.but don't know How.since my cross tab query is not monthly and my columns are changing,I can't make a report out of it, that's why I wanna print it directly. tnx for your advice in advance. ... 4 May 2010 00:16