Solved: access 2003 query by last date

Barbos · 10-Nov-2009, 10:09 AM #1

Hi

I have a Users DB that I cannot make any changes on it. One of the fields has a Date field. I need to run a query on that table to create reports, but the query creates multiple records for the same user with the only difference in the Date filed. I need to have only the records with the latest date in the Date field.

Is there a way to set a query that does this?

Thanks,
Barbos

OBP · 10-Nov-2009, 10:28 AM #2

You need 2 queries, the first has the userrecordId and date fields, set Totals>Grouping the userrecordid Grouped and the date set to Max.
Then in the second query you want the main table and the 1st query joined by the userrecordid and the date.
So the first query finds the last and the second show the data from just that record.

Barbos · 12-Nov-2009, 01:58 PM #3

Hi OBP

It worked!
(Sorry I did not respond eralier)

Thank you very much for your help,
Barbos

Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard network printer problem ram registry router security slow software sound toshiba trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!