how to generate unique labels

You could have a simple table with one column and one row.  

This table would then house the last label (Number) that was used.

Each time you create a label, you increment this number by one and so on.

The table would always hold the last number used.

Rog

hi
it's confuse
how do i implement this idea

Ok, easier solution.

You have a table in your database that holds rows of data of each item.

The table (Items) table, should have columns
Description
Price
Entered date.

You can add a column to this table say ID and set the property of the column to be Autonumber.

This will automatically create a unique number for each row in the table and new rows that are added.

Rog

titorober23,

You already have the same question open here:
https://www.experts-exchange.com/questions/23780010/I-WOULD-LIKE-TO-GENERATE-UNIQUE-NUMBERS-IN-A-REPORT.html

Please do not post duplicate questions.

If you are not getting responses, please click the request Attention button in your original question.
and explain the situation.
Creating a duplicate question simply confuses things here and experts do not know which question you will eventually delete when you get your final answer.

Situations like this are what the "request attention" button is designed to deal with.

So, now, *please* click the request Attention button in your original question, and ask for help in resolving this issue.
;-)

Thanks.

JeffCoachman

Hi
I understand adding a new field o that table, but the numbers of records won't grow as fast as the numbers of labels that i want to generate.
i need an example how to generate unique numbers, everytime that i request them.

You must be printing more labels than items?

You could create a label table.  Have a row for each label you print.  In this table have a column that is set to Autonumber.  WHen you print a label, you can then add a row.  Using the Autonumber field as the label.  

Rog

I have the same idea, but how do i append n rows to a table everytime that i request n labels