Union Query Problem (1 Viewer)

[reinaer]

I'm trying to set up a union query to combine a bunch of my tables. I needed to add another column to the tables and did that. However, now when I run my union query, it asks for a parameter value, which it did not do before. When I get rid of the new column in the Union Query, it no longer asks for a value. How can I get it to just combine the tables together with the new column? Here is what I am using for my union query.

SELECT [P/N],[Description],[Customer],[Price],[MinOrderQTY],[QTY],[U/N],[Year],[EffStart],[EffEnd]
FROM [STS]

UNION ALL SELECT [P/N],[Description],[Customer],[Price],[MinOrderQTY],[QTY],[U/N],[Year],[EffStart],[EffEnd]
FROM [STS AWACS];

UNION ALL SELECT [P/N],[Description],[Customer],[Price],[MinOrderQTY],[QTY],[U/N],[Year],[EffStart],[EffEnd]
FROM [KHI];

 

[Pat Hartman]

Are you sure that you've spelled the new name correctly? You seem to use embedded spaces and special characters in your field names (both are poor practice). Perhaps there is a stray space that is hard to see.