Date Query (yes another one!)

Witchity

Registered User.
Local time
Today, 15:21
Joined
Jan 22, 2003
Messages
15
How can I set up a query to show the most recent entries in a database? These could typically be a week back from whatever the current date is when the query is run.

Hope that makes sense! Thanks:confused:
 
???????????? Looked up the Max function and just got some about SQL queries - scary! What are they?!!!!

Word of one syllable please (I'm blonde!)
 
In very simple terms, use a totals query, groupby on the fields you want to display, select Max for your date field, you might have to use two queries to get the correct result
 
Select Max from where? I tried typing Max into the Criteria field and just got an error message saying data incompatible. I've got a dog called Max, but I guess that's not much help!

Sorry to be a pain but I'm an Access virgin, and rapidly beginning to realise why!
 
To create a Totals query click the Sigma button on the toolbar access will add groupby on the Totals line, select Max on your date field from the drop down list of available functions
 
Murky Buckets as the french say Rich! Thanks for that
 

Users who are viewing this thread

Back
Top Bottom