Recent content by WXIONG06

Isn't UNION used to eliminate "Duplicate" entries? I have duplicate entries for tracking purposes because each team member put their activities in differently

Okay, Found my answer.... I put a comma at the end of the third set of UNION ALL SELECT of "AS Expr1"

These query is linked to a the the tables which are linked to an excel spreadsheet. And the spread gets updated everyday so I want the query to be updated as well so I can't just copy and paste.

the "The SELECT statement includes a reserved word or an argument name that is missppelled or missing, or the punctuation is incorrect." I'm trying to place three linked query into on query. The code works on until I added this language: UNION ALL SELECT [Tony Chin].DATE, [Tony...

If you don't mind, I would like to cont this tread since I have a similar question, I just copy and past from my query and getting the same error msg. Here's what I have, "SELECT Bill.Date, Bill.RESEARCHER, Bill.CREATOR, Bill.REVIEWER, Bill.[PASS/REJECT], Bill.[WHAT WAS MISSED?]...