Thanks for the suggestions, but are we sure that my query (w/ the subquery) is valid for MS Jet SQL? I tried an analogous query on a different pair of tables and it doesn't work, either. Here, too, when I replace the subquery with a number, it works. So I still suspect that it's the subquery...