Assigning the value from the last record in a table to a variable.

[Mike]

Hi, i was wondering how i can assign the last value of a column called
'NumberLeft' in a table 'tblMisc' to a variable called 'NumberLeftCode'?

 

[Allen Browne]

Use DLookup() to find a value in a table.

Use DMax() if you are after the highest value.
If DLookup() cannot provide the record you need, see the extended DLookup()
in this link:
http://allenbrowne.com/ser-42.html

If you need help on how to use DLookup(), see:
http://allenbrowne.com/casu-07.html