newbee - error 3001 Invalid Argument running append query

[Guest]

error 3001 Invalid Argument running append query

I run an append query fine, then out of the blue it wants to give me this
error.
I noticed when I changed my access query to simply a select query, I do not
get the error. I research and someone said it was often caused by corrupt
record in table I am querying, but I get the same error when I query other
tables. I do not think a corrupt record is causing this.

any clues???

 

[MacDermott]

Open your query in Design View.
On the toolbar, click View - SQL View.
Copy the text from that window, and paste it into a post to this newsgroup.
This is the best way to show us exactly what your query is doing.

 

[Guest]

INSERT INTO GroupLookUpIncludingInactive ( Name, [Number], Prod, Term_Date,
Termed_By )
SELECT agrpmst_1.gmname, agrpmst_1.gmgpno, "1" AS Prod, agrpmst_1.gmtmdt,
agrpmst_1.gmtmin
FROM agrpmst_1;

 

[MacDermott]

Is Prod a text field, or is it numeric?

INSERT INTO GroupLookUpIncludingInactive ( Name, [Number], Prod, Term_Date,
Termed_By )
SELECT agrpmst_1.gmname, agrpmst_1.gmgpno, "1" AS Prod, agrpmst_1.gmtmdt,
agrpmst_1.gmtmin
FROM agrpmst_1;

Open your query in Design View.
On the toolbar, click View - SQL View.
Copy the text from that window, and paste it into a post to this newsgroup.
This is the best way to show us exactly what your query is doing.

do
not