By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,681 Members | 1,864 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,681 IT Pros & Developers. It's quick & easy.

Printing reports from a list

P: n/a
I have a report (invoice) that I need to print at the end of the day
for each order I shipped that day.
I can generate a list of the invoice numbers in a table I need printed,
is there a way to print all required reports for that day from a table
that contains only the invoice/order number?
Each report runs a query on 2 different tables, any suggestions?

Oct 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 12 Oct 2006 11:12:21 -0700, "ReggieRegister" <ch***@dayus.com>
wrote:

An invoice report can print more than one (invoice) record at a time.

Take a look at the "Print Invoice" code behind that button on the
Orders form of the Northwind sample application (search your computer
for northwind.mdb). The reason it prints one invoice is because the
query "Invoices Filter" specifies that in its WHERE clause. Take out
that clause and replace it by one that restricts to today's date (or
better, to a date range provided on a criteria form), and the report
will print multiple invoices.

-Tom.

>I have a report (invoice) that I need to print at the end of the day
for each order I shipped that day.
I can generate a list of the invoice numbers in a table I need printed,
is there a way to print all required reports for that day from a table
that contains only the invoice/order number?
Each report runs a query on 2 different tables, any suggestions?
Oct 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.