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
