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?