Printing a query

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

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.


--
Rick B



"Annette" wrote in message
...
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,
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" wrote:

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.


--
Rick B



"Annette" wrote in message
...
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

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.


--
Rick B



"Annette" wrote in message
...
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" wrote:

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.


--
Rick B



"Annette" wrote in message
...
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,

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

"Rick B" wrote:

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.


--
Rick B



"Annette" wrote in message
...
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" wrote:

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.


--
Rick B



"Annette" wrote in message
...
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