Make Table Query Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy - 01 Nov 2005 22:29 GMT

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

Reply to this Message

Jeff Boyce - 02 Nov 2005 13:51 GMT

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").

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> Hi,
> I made a query and it runs fine. But when I tried to save the result by
[quoted text clipped - 8 lines]
> Thank you in advance
> Kathy

Reply to this Message

Kathy - 02 Nov 2005 15:39 GMT

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

> Kathy
>
[quoted text clipped - 15 lines]
> > Thank you in advance
> > Kathy

Reply to this Message

Jeff Boyce - 03 Nov 2005 02:57 GMT

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

Have you tried re-building the query?

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> Thank you for the reply. The KEYFSAS is a text-type field.
> Kathy
[quoted text clipped - 18 lines]
> > > Thank you in advance
> > > Kathy

Reply to this Message