Error message on query

[Guest]

I'm getting the error message "data type mismatch in criteria expression" when running the following union query

SELECT RecID, PeriodName, GDYEAR, GDMNTH, SalonID, EmplID, PRCNM, PRDOHE, JobCode, Account, Payrol
FROM [qsel Independant Contractors]
UNION ALL SELECT RecID, PeriodName, GDYEAR, GDMNTH, SalonID, EmplID, PRCNM, PRDOHE, JobCode, Account, Payrol
FROM [qsel Payroll (AS/400)]

Any ideas what is causing this error message to appear

 

[John Spencer (MVP)]

Perhaps the semicolon at the end of the first query?


SELECT RecID, PeriodName, GDYEAR, GDMNTH, SalonID, EmplID, PRCNM, PRDOHE,
JobCode, Account, Payroll
FROM [qsel Independant Contractors]
UNION ALL
SELECT RecID, PeriodName, GDYEAR, GDMNTH, SalonID, EmplID, PRCNM, PRDOHE,
JobCode, Account, Payroll
FROM [qsel Payroll (AS/400)];