i want to make auto generated item number look like this
item001
item002
and so on
when i saved the item001 the next time i try to input new item it will give me item002 and so on...

Thank You.
i am using ACCESS

Recommended Answers

All 4 Replies

Where you are saving the items in database or some where else?

Where you are saving the items in database or some where else?

i am using access sir.

since you are storing the data in the DB , need to read the max of existing number and increment the same by 1 to get the new number and concatenate the same with your string.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.