Write Name of Report Query in Report Footer

S

Steve Stad

Is it possible to programmatically write the name of the query the report is
based on in a text box in the report footer.
 
A

Allen Browne

Steve Stad said:
Is it possible to programmatically write the name of the query the report
is based on in a text box in the report footer.
Click to expand...

Place a text box on your report, and set its Control Source property to:
=[Report].[RecordSource]
 
S

Steve Stad

Thank you mate.

Allen Browne said:
Steve Stad said:
Is it possible to programmatically write the name of the query the report
is based on in a text box in the report footer.
Click to expand...

Place a text box on your report, and set its Control Source property to:
=[Report].[RecordSource]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

.
Click to expand...
 

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

Report Group Footer DLookUp 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
A03 - count in report footer gives me #Error? 0
Footer text appears "squished" 1
Weekly Report 2
Report Width, why 23" not 11" 0
Program buttons to create a word document 0
List name of report in footer 2

Top