most current date

J

Josh Henry

Hi,
My old query that used to look for anything >#12/31/03# used to be
sufficient and each year i would change the year because there would be only
one record per year. Now that is changing and i was wondering if there are
any functions---how i could query for the most recent record. thanks.
 
D

Duane Hookom

Try to think if you have provided enough information for us to provide more
than a generic guess at a solution. Pretend you can't see your table,
fields, or data and know very little about your requirements.

Then, try to come back with the information that makes providing a solution
more realistic.
 
J

John Spencer (MVP)

Guessing without sufficient details.

Look up DMAX in the online help (VBA function)

Try using a query using the Max Function against your date field.
 
Top