Access function to return query name in the query results

Question

Hello,

Does anyone know if there is a way to return in the results of a query the query name ? Is there a function to return this result ? I have tried dlookup but cannot find any right arguments to achieve that, maybe not supported by the specific function ?

Thanks in advance

Dimitris

Answer 1

I'm having trouble understanding a business case for changing query names.

Answer 2

Thanks Hans.

The problem I am trying to avoid is if & when the name of the query is changed and the best option I have figured until now is to enter a parametric field where I input manually the query name but that's obviously not a very good solution.

It is a pity there is no option to address this issue because I want this info in my reports to easily find the query name that generated the report results that I transfer to Excel.

Thanks anyway !

Answer 3

There is no support for this. If you really need this, you'll have to manually add a column, for example:

QueryName: "MyQuery"

It is up to you to enter the correct name, and to update it if you change the name of the query.