I was curious to know if there was any way to assign a unqiue record number to a report that will not be repeated again. (ex. Invoice#, PO#, etc).

My goal was to create a receiving report for our company with a unique "receiver" number assigned everytime we receive some item in to stock. This "receiver number" cannot be repeated for another receipt, so it must be unique.

 

Thank you for all of you help in advance.....

  Typically your database would store that value, and your application or database would create it, and the report would just print the value that is stored in the database.  That way, if you need to reprint the invoice, it still has the original number.

 

Perhaps you could use a combination of the date + Time + milliseconds to get a pseudo-unique number.

 

Quinton

The problem is that our database/application does not have this particular report. i wanted to create this from scratch. But you suggestion of Date+time+millisecond seems to be logical.