I have a number of append queries that show different errors from the source data. Is there a way that I can show the name of each append query in the append table so that it's easy to see what the error is? Thanks in advance
I have a number of append queries that show different errors from the source data. Is there a way that I can show the name of each append query in the append table so that it's easy to see what the error is? Thanks in advance
I'm not sure I understand what you want, but if you want the name of the query to be saved in the append table, add a text field (maybe "WhichQuery") to the append table. Then, in the append query, add a column that looks something like this
QueryName: "qryReport1"
(change the name "qryReport1" in each query to the real name)
In the append query, append the column "QueryName" to the field "WhichQuery" in the append table.
Since the column "QueryName" in the query is a constant, every record that is appended should have the name of the query entered in each record.
It is a lot of manual effort, but I don't know how to get the query name from the query while it is executing.
Hi Steve
Many, many thanks for this - it's exactly what I wanted