find most recent date

  • Thread starter Thread starter dee
  • Start date Start date
D

dee

I am trying to go through a rst. of all customers and
query the last document number only, for each custID.
I am driving myself crazy.
Any ideas?
Dee
 
Dee,

You can group set totals within the query and in the date
field, instead of Group By choose Max or Last.

Scott
 
Back
Top