By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,062 Members | 1,374 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,062 IT Pros & Developers. It's quick & easy.

add query name to query output

P: n/a
I would like a field in a query to contain the name of the query that
is producing the data, in order to maintain transparency of data flows
when the data is copied into Excel. Is there any way of returning the
query name in a field expression? The query is being run manually
rather than through code.

Thanks

Dec 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 22 Dec 2006 11:00:53 -0800, ka*******@freeuk.com wrote:
I would like a field in a query to contain the name of the query that
is producing the data, in order to maintain transparency of data flows
when the data is copied into Excel. Is there any way of returning the
query name in a field expression? The query is being run manually
rather than through code.

Thanks
Simply add another column to the query grid.
QueryName:="This is the query Name"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Dec 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.