* Title when printing results of a custom query

[kfunk_ia]

I have created a query that takes three parameters, County, Start and End. This query generates a result set of all people married in a specific <County> between <Start> and <End>. The query works just fine for my purposes. What I want to do is have the title of the report (when I print out the results) read something like 'Marriages in Jones County', where Jones was the value supplied when the query was ran.

On the General tab of the query window, is there an expression that can be used in the title field to automatically add the entered <County> after the string 'Marriages in'? This way I don't have to manually change the title every time I run the query.

[tatewise]

That is explained in FHUG Knowledge Base An Overview of Queries under Printing the Results Set from a Query.

Use the code =Text(["County"])

[kfunk_ia]

It may be in the knowledge base but unfortunately it didn't seem to turn up when I used the Search box.

I can attest to the fact that using %["County"]% causes the who program to crash when choosing either Print and Print Preview.

Thank you!