How to append data with selected data plus values?

[tetsuo2030]

Greetings,

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:

"INSERT INTO tbl_errors SELECT tbl_source.* FROM tbl_source WHERE [condition 1]...;"
 

"
combined with:

"INSERT INTO tbl_errors.[Error Type] VALUES (qry_append_1)...;"
 

Do I need some sort of UNION of the two?

[TheSmileyCoder]

Im not 100% sure, but I think this should do:

INSERT INTO tbl_errors SELECT tbl_source.*,'qry_Append_1' FROM tbl_source WHERE [condition 1]...;

Notice the single ' around the string qry_Append_1

[tetsuo2030]

This is close!! I figured it out:

"INSESRT INTO tbl_errors ([fld1], [fld2], ..., [Error Type]) SELECT tbl_source.[fld1], tbl_source.[fld2],..., 'qry_append_1' AS [Error Type] FROM tbl_source WHERE...;"
 

[TheSmileyCoder]

Im very glad that you got it figured out.