You're using way too many parentheses and doubel quotes instead of single quotes
Code:

SELECT Groups.Command, Groups.GroupName

FROM Groups

WHERE Groups.Command='BackFolder' AND Groups.GroupName='Medical Records';

or
Code:

SELECT Command, GroupName

FROM Groups

WHERE Command='BackFolder' AND GroupName='Medical Records'

However, this query does not make sense as the return will be zero or more recordsets containing only the words "BackFolder" and "Medical Records".

Edited by sealeopard (2003-12-15 10:33 PM)
_________________________
There are two types of vessels, submarines and targets.