DLookup for last value entered?

[JimO]

I am very new to Access so this will be on a very very basic level.



I am trying to return the last value entered in a column based on the last date. If I were to write this for Excel I would use Index and the Max value from a date column. I have tried using DLookup and the date but my problem is the date is not always today's date.

=DLookUp("INR","WarfarinT","Date=Date()")

returns a 'Blank' value and,

=DLookUp("INR","WarfarinT","Date=>Date()")

returns an '#Error'.

I'm looking for the last value in column 'INR' from the 'WarfarinT' to be returned to a form. The first example works if the last date entered is equal to today, but being very new to Access I am not sure if I am on the correct tract or not.

Thanks
Jim O

[June7]

This does get tricky. Options are a TOP N query or nested subquery or more complex domain aggregate. Will there be only one record for each date?

=DLookup("INR", "WarfarinT", "[Date]=#" & DMax("[Date]", "WarfarinT") & "#")


Date is a reserved word - should not use reserved words as names. Note the [] because of this.

[JimO]

June,

Thanks for the response. That seems to do the trick.

Jim O