Glad it worked out for you. Make friends with Google. When someone mentions 'alias the table', "ms access table alias" will tell you what you want to know - at least in the results.
Sorry to be picky about the code tags thing, but hopefully you can see how much easier it makes to read and (for us) troubleshoot code. It also prevents the insertion of spaces every 50 contiguous characters, which is what the forum will do. That just raises objections to things that aren't really there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.