simple access counter

counter

[brancook]

Hi everyone,

I'm in need of good little database to assign serial numbers to a product. What I need is something simple and fool proof. What I'm doing is creating product id labels in a program called Bartendar and I need the serial number tracking to come from a reliable source.

Is there a way that access can do this?

Thanks

[nickthompson]

Yes. Set up your table with a field with data type 'Autonumber'. At the bottom of the table design window you'll see a parameter called 'New Values', which is set to 'Increment' by default. Change this to 'Random'.

By default you'll get an 8 digit ID. Change the data type to 'Replication ID' if you want a (much) longer ID field.

Nick

[brancook]

Thanks Nick,

I'll give that a shot.