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.
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
