Printing a query

[Guest]

I made a query from my table. I would like to print some records not all of
them from this query all on one page. Is there a way to do this? Thanks for
your help.
Annette

 

[Rick B]

You print reports, not queries. Build a report and print that.

To print only certain records, you need to further scale down your query
results so that only those certain records appear in the results.

 

[Guest]

Rick,
Thanks, Can you tell I’m new to access. What I’m doing is creating a query
to bring up all invoices that are not paid. What do I put in the criteria
field to bring up invoices that have nothing in that field. Its the “paidâ€
field. From this I want to print this information. So I’m guessing that I
need to make a report to do that. Any help will be greatly appreciated.
Thanks in advance.

 

[Rick B]

What type of data goes in the "paid" field? Is it a checkbox or a date
field or a yes/no field?

Assuming it is a date, In the criteria under the "paid" field put...
Is Null

If it is an amount, you will use the same, or maybe...
=0

If it is a true/false field you can use...
=0

or

False

Once you get the criteria right, you should only see unpaid items in your
query. You can then create a report based on that query using the report
wizard.

 

[Guest]

Rick,

Thank you very much! It works great! I have the date in the paid field.
You saved me a lot of time. Thanks again.

Annette