Add Invoice Number to Report

[Randy Christiansen]

I have created a delivery table that contains all of the usual fields ,
Pickup, Delivery, Billing, NoPeices, Weight... etc. The table is updated
with current delivery information daily. At the end of the week I create a
report grouped on Billing customer that prints an invoice with all of the
unprinted deliveries the customer is paying for... the report works fine.
What I need to figure out is how to assign a unique invoice number
(autonumber) to the report that will be associated with each Billing customer
for that print period. Can I somehow generate a unique number at the time I
create the invoices.

I hope this is not too confusing and thanks for any help you may offer.

Randy

 

[Arvin Meyer [MVP]]

You must write a record to the table to make it "stick" You can easily print
a value on a report, but it won't repeat unless it's saved. Normally, this
InvoiceNumber is created when the records are created. Take a look at the
Orders and OrderDetails tables in the Northwind Sample database to see how
is it can be achieved.

 

[Randy Christiansen]

I had forgotten about Northwind... thanks for pointing me in that direction.