Error message on query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)];
 
Back
Top