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
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
