I need to include a unique number on a report (think of it as a packing list), preferably without having to use VBA code. With Oracle I would SELECT from a sequence. What is the Access solution? Thanks.
I need to include a unique number on a report (think of it as a packing list), preferably without having to use VBA code. With Oracle I would SELECT from a sequence. What is the Access solution? Thanks.
No sequence in Access.
You could simply assign a number of your choosing.
See this -- not quite on topic but may be helpful.
How many numbers do you need?
What is the significance of the number to user (or business)?
You could create a Random Number.
An alternative is a textbox with
=1
as the control source, with its running sum set appropriately. It's not going to save anywhere, but it will provide a numbered list on a report.