DLookup Function

L

Lisheen

Hi All

I was wondering if someone could tell how I get a DLookup Function t
return the last or latest record. I have a DLookup Function whic
looks up the date field for a given user. If this user has more tha
one record in the table I need the DLookup function to return th
latest date. Is this possible.

Thanks for your help.

Rgds

Nora
 
A

Al Camp

Lisheen,
Use the DMax function to find the latest Date for a user. Use your key
field to identify the correct user in the "Where" portion of the function.
 
M

Mauricio Silva

Did you try using DMax?
You can return the max value for a certain criteria, which could mean the
latest one, depending on your data.

Mauricio Silva
 
Top