look up last record

[Porky]

When using DLookup IE =DLookup("[TillTotal]","Petty Cash" can i get it to look at the latest record and not the first by the date in the table basically it works fine if you do it once a day but if there are 2 entries for the same day it always recalls the first?

 

[KenHigg]

Do you have an autonumber as the primary key?

 

[Porky]

yes it is the paymend id, the rest of the table are, Date,Amount,Reason,TillTotal,Up/Down,PettyCahType. The last one there is a look up Combo Box to a seperate table with only 2 cols and 4 records, this works fine.