Query Question

jacob · Apr 28, 2005

Can you combine multiple queries in Access using the union, union all,
intersect, and except operators? I'm using Access XP and 2003

Thanks!

MGFoster · Apr 29, 2005

jacob said:
Can you combine multiple queries in Access using the union, union all,
intersect, and except operators? I'm using Access XP and 2003

Access can use the UNION and UNION ALL, not INTERSECT nor EXCEPT.

jacob · Apr 29, 2005

Thanks!

MGFoster said:
Access can use the UNION and UNION ALL, not INTERSECT nor EXCEPT.