Add Invoice Number to Report

  • Thread starter Thread starter Randy Christiansen
  • Start date Start date
R

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
 
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.
 
Back
Top