Unique number for Reports (1 Viewer)

[Ants]

Within our database we have the facility to either print or view invoices which are reports. The report is made up from a query filter selected from the current record in the form. We need to create a unique number for the invoices whenever a new invoice is created with that record in the form. In a way it is like an auto number in tables. The trouble is that all the records share the same report so each record does not have a unique report. The invoices are sent off at the same time.

I would be most grateful if anybody could help! (I will be amazed if anybody can understand what I want!!)

 

[Richie]

If your invoice details are stored within a seperate table which they should be then just give that table an auto number and use it on the relevant report, you could also add the customer id no. and string them together to to enable a quick reference to both.
HTH