Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2007

Tip: Looking for answers? Try searching our database.

Add Invoice Number to Report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Randy Christiansen - 29 Dec 2007 20:08 GMT
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] - 29 Dec 2007 20:35 GMT
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.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have created a delivery table that contains all of the usual fields ,
> Pickup, Delivery, Billing, NoPeices, Weight... etc.  The table is updated
[quoted text clipped - 12 lines]
>
> Randy
Randy Christiansen - 29 Dec 2007 20:51 GMT
I had forgotten about Northwind... thanks for pointing me in that direction.

> 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
[quoted text clipped - 17 lines]
> >
> > Randy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.