OK I already know the answer - yes I can query more than one table because I have done it before. But now as soon as I add the second table, I get no results in the query. I know there should be some results. what am I missing?

thanks

There is no match on the Join fields?

Brian

yes there is