T
Tom
I want to make a quary go to the last record
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Hans Up
Tom said:I want to make a quary go to the last record
Can you give us more information to work with?
T
Tom
My record has a serialized (09-001) number and I want to create a query to
find the last record then I will add one to the new record to get my current
record
find the last record then I will add one to the new record to get my current
record
H
Hans Up
Tom said:My record has a serialized (09-001) number and I want to create a query to
find the last record then I will add one to the new record to get my current
record
OK. Say your field is named serial_num, and the table is called tblFoo.
You can order descending on serial_num, and retrieve only the Top 1
record.
SELECT TOP 1 serial_num
FROM tblFoo
ORDER BY serial_num DESC;
I made that suggestion because you asked for a query. Another approach
is the DMax() function. So, in a VBA subroutine, you might try:
CurrentMaxSerialNum = DMax("serial_num", "tblFoo")