Info at the report's footin

Ana · Sep 30, 2005

Hi,

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

TIA

Ana

Al Camp · Sep 30, 2005

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