Syntax for DMax

S

Stonewall

I am using access 2003. I have a form with a text field. This statement
works fine but it returns the date from the first record and I need the date
from the last record. Do I use DMax and if so where would I position it in
this statement ?


=DLookUp("[Date]","[attendance_clock_in]","[StudentID] = " & [Employee ID])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top