I prefer doing the sql that way too... didn't know that I could use q{} to accomplish it thanks.
Thanks for the table aliasing tip I didn't know about that
As for putting the table names in front of things, I don't like to, but I think Access bombed the last time I tried to leave them out. I'll give it a shot when I'm @ work on monday. Thanks !