Info at the report's footin

A

Ana

Hi,

How to show the name of the QUERY file at the footer of the report like the
page number?

TIA

Ana
 
A

Al Camp

If your query is a "saved" query...
=[RecordSource]
will display the name.
If your query is "resident" to the report (an SQL statement)
=[RecordSource]
will display the SQL statement.

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Top