Query Title When Printed

[mikeTTI]

I have a cross_tab query, that users print on a monthly basis.

The user selects whether they want to include data for one or all of three products. So the query could show data for example for Salmon only.

I need to be able to show on the printed query, what products it is displaying for. At the moment the query is called "TotalxProccessor_Product". Once the query is printed there is no way to tell if it is for Mussels, Salmon, Oysters or all three products.

Is there an easy way to manipulate the title the query prints our with?

Or do I have to go through a report to have control?

 

[boblarson]

Reports - meant to be printed

Queries - meant for recordsources of forms/reports/exports, etc. but not as many printing options as reports.

So, you probably will need a report to do what you want.