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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a ck mark? 24
A03 - count in report footer gives me #Error? 0
My reports stopped working 3
Hiding info on page header 1
FIeld with more than 255 char on report 0
Group last line of details and report footer 0
Report Footer Error on Page 2+ but shows on first page 3
Unable to add in a report 2

Top