Get Name of This Query

[Harry Shmedlap]

When I run this query I want a new column to show the name of this query. Any idea how I can do this?

 

[MStef]

Look at "DemoQryNameColumnA2000.mdb"

 

[Harry Shmedlap]

Thanks for your response but it seems like you just manually entered the name of the query. Thats not what I want. I want it automatically entered. I have about 20 queries that I run sequentially, each one adding its own records to a single common target table. When I look at that table I want to see which records came from which query. I don't want to start manually entering the names into each query, especially since if the name changes, I will need to remember to change the text inside.
What I am looking for is some function that will return the name of the current query.

 

[MStef]

if you have 20 queries, put this in each query. When you run any query, it will to leave his name in the table.

 

[Harry Shmedlap]

Put what in each query?

 

[MStef]

Look at my query, where is the name of query ???

 

[Harry Shmedlap]

But you entered that as a fixed string!

 

[neileg]

How are you running these queries? If the name is changing, you'd have to change the code you are using to run them, wouldn't you?

 

[MStef]

It seems to me I,m silly.