Queries

GET ONLY LAST DATE
I have a table in Access call RQ. In the queries design view of access, i have a field called RQ_QTY_ISS from the RQ table. I would like to get only the latest date of this field to show on the report, how can I do that? What shall I put in Criteria on the query to only get the lastest date of this field? P... 15 Jun 2006 17:00

Unmatch return query
Hello, i newbie in queries and try the unmactch query but only one field is compare I have 2 tables (T1,T2) with identical fields Emp NUMBER StartDate DATE EndDate DATE Ex. T1 | Emp | StartDate | EndDate | | 100 | 2006-01-02 | 2006-01-10 | | 100 | 2006-05-02 | 2006-05-10 |(1) | 1... 15 Jun 2006 10:12

Time Taken Calculation
I have two tables that I need to create a query to do some calculations between. Table 1 Stores: Employee ID, Vacation Time Allotted, Personal Time Allotted, and Holiday Time Allotted Example: Employee 123 has 140 hours of vacation, 40 hours of personal time, and 88 hours of holiday time. Table 2 Stores... 13 Jun 2006 12:37

Aggregate Function
Hi all. I've tried finding an answer to this and can't find one somewhat close. I'm getting an "You tried to execute a query that does not include the specified expression <name> as part of an aggregate function." error . I've put in some IIf statements to prevent Overflow or the Can Not Divide by Zero however now ... 12 Jun 2006 12:09

salary
what does $30.000 a year work out to? (an hour) ... 4 Jun 2006 00:40

salary
starting a new job. the starting salary is $30.000 a year ... what is the hourly rate? ... 3 Jun 2006 16:27

Deleting records
This table I am working on contains a large number of records containing data about students. The first 2 fields identify the student uniquely; the third field contains one bit of the data. There are about 9 records for a student, each containing different kinds of data in the third field. The records for a ... 6 Jun 2006 11:34

UPDATE with INNER JOIN
UPDATE temp1 INNER JOIN Data2 ON temp1.[Date]+temp1.[Time] = Data2.[Date]+Data2.[Time] SET temp1.Data2 = Data2.Data2 running that against tables with approx 500,000 records causes the CPU to go to 100% and it ran overnight before i killed it although it doesnt produce a syntax error there is a problem. So wha... 12 Jun 2006 18:24

trigonometry Functions
I have used the following funtion in Excel: =COS(RADIANS(P12))*T12 The COS function is supported in Access, but I am having problems finding a "Radiens() function to use Can anyone help? ... 1 Jun 2006 04:34

Running Count
I have this input data. 1/1/06 2/3/06 3/6/06 I want the query to return 1/1/06 1 2/3/06 2 3/6/06 3 I am working in Access 97. Any help would be appreciated. -- M. Shipp ... 30 May 2006 07:26