If you run it in a new query in access' query designer, what does it highlight or does it run fine? Looks ot be missing a closing parenthesis but not sure itf it was just a copy/paste issue to your post.