By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,192 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,192 IT Pros & Developers. It's quick & easy.

Incrementing number field manually

P: 1
I am not a programmer and a newbie with MS Access.
I hope you guys can help me with my problem.

I'm creating an IT hardware inventory database for my company.
We have a few branches and each branches will have their own branch code.
For example :- PKGL07
PKGL14
KLIA
HQ
and so on....

When a user adds a new hardware, the system will assigned a hardware code
PKGL14-001 for the PKGL14 branch hardware no 1 or
KLIA-001 for KLIA branch hardware no. 1 and so on...

I managed to create the hardware code by following some example on the net using DMAX and string concatenation and by creating a counter table with branch code and number field.

TABLE tbl_TempCounter
FIELD BranchCode
Counter

My problem now is how do I increment the counter number in the tbl_TempCounter according to the branch so that I can get the next number for my hardware code.

I hope my explanation is clear enough.
Aug 9 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.