most current date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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