FWIW, if you are a relative novice at creating SQL statements in Access, the query designer will do a very nice job for you and make troubleshooting such statements much easier. (I even use the SQL Server query designer on occasion.)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!