SQL in Access is not T-SQL which is what SQL Server uses. Posting in a SQL Server forum is going to get you a SQL Server answer.

There is a forum on SSC dedicated to Access and I am sure there are people familiar with Access on ssc that would help if they knew you had an Access question.