This is probably an easy thing to do, but I can't seem to figure it out. My main data set is a massive table with 15 columns and thousands of rows. The data entry form forces certain consistencies in the data (if column A = "bluejay", column B = "bird"). However, I've agreed to upload archived data from a previous source where these consistencies were not enforced. So, I wrote 10 or so queries looking for specific inconsistencies.
What I want to do is simple: I want to turn those 10 select queries into append queries and add them to tbl_errors; tbl_errors has one extra column called 'Error Type'. When when qry_append_1 adds its lines, I want it insert a value into tbl_error.[Error Type], something that simply tells me what query it came from (the text "qry_append_1" would be fine).
It's got to be something like:
Expand|Select|Wrap|Line Numbers
- "INSERT INTO tbl_errors SELECT tbl_source.* FROM tbl_source WHERE [condition 1]...;"
combined with:
Expand|Select|Wrap|Line Numbers
- "INSERT INTO tbl_errors.[Error Type] VALUES (qry_append_1)...;"