Re: How to set a Unique number for Barcode values in MS Access
I am not sure what you are asking because I can think of several possible interpretations of your question. If you want a unique number for a customer, you might wish to see if there is a customer number used as a Prime Key (PK) in your list of customers. Per Access rules, a PK is necessarily unique for any single table. The PK, if assigned as an autonumber field, starts from 1 and can be defined to auto-increment when you add a new customer, so that is about as "minimum" as it gets. It would be suitable as a way to reference customer files, I suppose.
You mentioned some algorithm and asked whether it was OK to use but did not name the algorithm so I can't address that part of the question. I also don't know where barcode values fit in for your question.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.