0

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

Edited by nullclick: n/a

3
Contributors
4
Replies
6
Views
6 Years
Discussion Span
Last Post by Saikalyankumar
0

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

i am using access sir.

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.