find most recent 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
 
S

Scott

Dee,

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

Scott
 
Top