If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Printing a query
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 |
#3
|
|||
|
|||
Printing a query
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 |
#4
|
|||
|
|||
Printing a query
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 |
#5
|
|||
|
|||
Printing a query
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 |
Thread Tools | |
Display Modes | |
|
|