Union Query

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Can anyone tell me why my Union Query doesn't want to
work? A newbie at these...

Select * from qryMarkSummary2 UNION Select * from
qryArchiveSummary
WHERE (((Year([ProductionDate]) In (1999,2000,2001,2002))
ORDER BY ProductionDate;
 
Eric said:
Can anyone tell me why my Union Query doesn't want to
work? A newbie at these...

Select * from qryMarkSummary2 UNION Select * from
qryArchiveSummary
WHERE (((Year([ProductionDate]) In (1999,2000,2001,2002))
ORDER BY ProductionDate;
Click to expand...

List the colum names in the SELECT clauses.
 
Back
Top