newbee - error 3001 Invalid Argument running append query

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

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???
 
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.
 
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;
 
Is Prod a text field, or is it numeric?

Newbee Adam said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top