Print "a" record.

  • Thread starter Thread starter Ted Clore
  • Start date Start date
T

Ted Clore

I have a report that takes information from a query. I want to only print
the one record from hundreds. My report gives me all the records in the
database. How can I make the report print only the record I am interested
in printing?

The database tracks jobs in the shop and when the job is complete I would
like to print a report about only that job.

Thanks for your help, again.

Ted
 
Ted said:
I have a report that takes information from a query. I want to only print
the one record from hundreds. My report gives me all the records in the
database. How can I make the report print only the record I am interested
in printing?

The database tracks jobs in the shop and when the job is complete I would
like to print a report about only that job.

Thanks for your help, again.

Ted
Click to expand...
How do you select that one record? Company name, Invoice number?
In the query for criteria in that unique field put [Enter Value Name Here]
Now the query will prompt you for a value each time before you run the
report.

gls858
 
Your a complete and utter gem. Thank you so much as that works perfectly.

Ted



gls858 said:
Ted said:
I have a report that takes information from a query. I want to only
print the one record from hundreds. My report gives me all the records
in the database. How can I make the report print only the record I am
interested in printing?

The database tracks jobs in the shop and when the job is complete I would
like to print a report about only that job.

Thanks for your help, again.

Ted
Click to expand...
How do you select that one record? Company name, Invoice number?
In the query for criteria in that unique field put [Enter Value Name Here]
Now the query will prompt you for a value each time before you run the
report.

gls858
Click to expand...
 
Ted said:
Your a complete and utter gem. Thank you so much as that works perfectly.

Ted



Ted said:
I have a report that takes information from a query. I want to only
print the one record from hundreds. My report gives me all the records
in the database. How can I make the report print only the record I am
interested in printing?

The database tracks jobs in the shop and when the job is complete I would
like to print a report about only that job.

Thanks for your help, again.

Ted
Click to expand...

How do you select that one record? Company name, Invoice number?
In the query for criteria in that unique field put [Enter Value Name Here]
Now the query will prompt you for a value each time before you run the
report.

gls858
Click to expand...
Click to expand...
Thanks for the feedback. Glad to help.

gls858
 
Back
Top