get highest invoice number from table

hullstorage

Registered User.
Local time
Today, 00:53
Joined
Jul 18, 2007
Messages
213
i have a table of invoice numbers and i have a form with a field for invoice numbers
what i want to do is get the last or highest invoice number last used from the invoice table by default

help!!!

many thanks
 
You can use a dmax() function to get the value and use that for the default value.
 
You can use a dmax() function to get the value and use that for the default value.


can you give me some idea on this
as i am fairly new to this and have never used the dmax funtion

thanks
 
May I suggest MS Access help and give it a go from there as a first step as my explanation of how to use it wouldn't be as thorough (And why try to re-invent the wheel?). If you get hung up after that post back what you've tried and I’ll give it a shot - :)
 

Users who are viewing this thread

Back
Top Bottom