View Full Version : Display Query Name On Report


butler9714
05-04-2005, 05:29 PM
How can I display the query name of a report in its footer?.

Ukraine82
05-05-2005, 11:21 AM
I'm not sure I understand the question, but did you using the label box?

hth
Michael

indyaries
05-05-2005, 01:01 PM
In a TextBox, place this:

="Data Source: " & [RecordSource]

I usually put this in the report header portion. Other useful info:

Database Name
="Database: " & [CurrentDb].[Name]

Report (or Form) Name
="Report: " & [Caption]