I am TOTALLY flummoxed with this one...
I have two tables. Both have the same number of columns, and the column names are exactly the same.
I'm trying to use a UNION query to combine them, which has worked previously, but now I keep getting the error "Enter parameter value: Query2.Legacy_ID_Article"!!
How can it be asking for this when there isn't a table called Query2, and the UNION is definitely referencing the two names tables (not another query)?
Please help!!!