Query

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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
Click to expand...

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dictionary/Field Index 1
Index - how to create/use an index in a quary 2
How do i create link with Access 2003 table/quary and Excel 2003 f 1
Use Dlookup() on report text box 2
Linking Tasks 2
Linking Projects 1
dates of birth and ages fields 1
Error -2147352567 (80020009), Access 2007 0

Back
Top