Newbie needs help - Sequential Numbering of a field for new record

C

Chas Large

Dear All,
I need to create new records with a field Record# (not the autono) and I
want it to be the next one after the last created. I have a table with Cust
Details and one field is RecNo. This will have data from an old paper based
system so RecNo will be a 4 digit no. For new records I want to find the last
RecNo, add 1 to it and use the new no for the new record.
I can use the MAX in a query to find the number but can't work out how to
get this into VB to do the add etc.
I guess this is not NEW and must have been done before, perhaps you know
where I can find this info, please point the way.
Do I need to create an SQL query in the VB code? or what.
Really a newbie at this, have searched this and other groups but no luck.
Cheers
Chas
 

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

Copy previous record into form field 0
Using query values for field name in table 10
Help to create and Insert New Target Date record in Subform 0
Finding the new Record 9
Sequentially Increment a Text Field Based on Select Criteria 11
Recreating a "legacy" function 4
Randomize records then select TOP (x) 7
Pulling Sequence Number Depending on Other Fields 6

Top