Make Table Query Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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").
 
I'm not spotting anything that would cause what you've described.

Have you tried re-building the query?
 
Back
Top