Need I say more, why is making up a working SQL Statement so hard.

This is striaght from MS Access SQL Viewer.

Code:
SELECT Groups.Command, Groups.GroupName
FROM Groups
WHERE (((Groups.Command)="BackFolder") AND ((Groups.GroupName)="Medical Records"));


Of course it does not work, and what ever I try fails, what should I be looking for to get this working. Apart from a new Job.

I have a Table called "Groups", Fields called "Command" and "GroupName".

Thanks