Make Table Query Problem

[Kathy]

Hi,
I made a query and it runs fine. But when I tried to save the result by
changing it to a make-table query, I got the message box "Invalid argument.".
The SQL statments are:
SELECT IP2003_04.*, MasterLookupFSAs.KEYFSAS INTO IP0304KeyFSAs
FROM MasterLookupFSAs LEFT JOIN IP2003_04 ON MasterLookupFSAs.FSA =
IP2003_04.FSA WHERE (((MasterLookupFSAs.KEYFSAS)="YES"));

This query is to filter through IP2003_04 for all Key FSAs identified in
MasterLookupFSAs.
Thank you in advance
Kathy

 

[Jeff Boyce]

Kathy

Is your KEYFSAS field a text-type field, or a Yes/No field? Your query/SQL
statement implies that it is a text field, since you are putting quotes
around the WHERE value (i.e., "Yes").

 

[Kathy]

Thank you for the reply. The KEYFSAS is a text-type field.
Kathy

 

[Jeff Boyce]

I'm not spotting anything that would cause what you've described.

Have you tried re-building the query?