G
Guest
I have many queries that append data to a table. One of these queries is a
query named: qryAppendCOS. This query appends data to table. Within this
query, I would like to be able to append the queryname "qryAppendData" to a
field, for all records that it is appending. I want to have the ability to
determine the source of the data contained in the table i.e. query name. I
know that I can manually type the query name to a "calculated", but my
question is....is there a function I can use in a calculated column to return
the query name to append to the database?
Many thanks
query named: qryAppendCOS. This query appends data to table. Within this
query, I would like to be able to append the queryname "qryAppendData" to a
field, for all records that it is appending. I want to have the ability to
determine the source of the data contained in the table i.e. query name. I
know that I can manually type the query name to a "calculated", but my
question is....is there a function I can use in a calculated column to return
the query name to append to the database?
Many thanks