Print "a" record.

[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

 

[Bill Edwards]

Use DoCmd.OpenReport with a "WHERE" condition.

 

[Ted Clore]

Thank you for the response Bill, where do I do this command at?

Ted

 

[gls858]

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

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

 

[Ted Clore]

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

Ted

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

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

 

[gls858]

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

Ted

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

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

Thanks for the feedback. Glad to help.

gls858