• Thanks for posting the code, David.

    When I tried to save it, I got thrown out of Access.  I was careful to change the '[' around the 2 SELECT statements to '('.  I am able to save the other queries that I have.  What gives?

    Robert