invoices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need to set up an invoice using info from my database - new to acces & can't
work out how to do this
thanks
 
hi,
you will need to create a select query that pulls the
required data from you database table.
you will need to create a report which will be the
invoice template and use the above select query as the
reports record source to populate the report.
you may need to create a form to run the select query
based on record key criteria
or if you already have a form for input into the table,
you may just need to add a button.(this part i am unsure
of since you didn't mention an input form.)
if you are unsure about querys reports ect
http://library.cui.edu/clic/access.html
http://mvps.org/access/
regards
Frank
 
You need the following tables:

TblCustomer
CustomerID
CustomerName
CustomerAddress
CustomerCity
CustomerStete
CustomerZipcode

TblOrder
OrderID
CustomerID
OrderDate
etc

TblOrderDetail
OrderDetailID
OrderID
ItemID
Quantity
Price

For your invoice, create a main report based on TblOrder and a subreport
based on TblOrderDetail.

I am in business to provide customers help with Access, Excel and Word
applications. I could have this up and running for you in a short time.
Contact me at my email address below if you would like my help.
 
Back
Top