Incrementing numbers

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I am trying to write a database that will allow for a
persons ID to be entered and how many items are associated
with this entity. Once the nuber of items have been
entered allocate an item type to each.

The record number or entity number is generated by the
Autonumber in the table and the number of items is added
by the user. The following is what I am trying to do

Case number ABC0004
Number of items 4
Item numbers to be allocated in table with type
ABC0004-001 Spanner
ABC0004-002 Crowbar
ABC0004-003 Hammer
ABC0004-004 Screwdriver

Please e-mail me off the list for any help you may have.

thank you

Keith
 

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

Excel Sequential Numbering System 0
Numbering documents (revised) 1
Insert row(s) with vba 3
Numbering documents 1
Counting Column 3
Update / append problem 2
Find a string in a column 1
Record output in queries 1

Back
Top