G Guest Oct 24, 2006 #1 I get an invalid argument msg in make table query but not in select query using exactly the same query.
I get an invalid argument msg in make table query but not in select query using exactly the same query.
G Guest Oct 24, 2006 #3 KARL DEWEY said: Post your SQL. Click to expand... SELECT [Tashman data06].* FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045")); Don't you need the mdb file?
KARL DEWEY said: Post your SQL. Click to expand... SELECT [Tashman data06].* FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045")); Don't you need the mdb file?
G Guest Oct 25, 2006 #4 Not need the .mdb but wanted to see your SQL for the make table query. JeffT said: KARL DEWEY said: Post your SQL. Click to expand... SELECT [Tashman data06].* FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045")); Don't you need the mdb file? Click to expand...
Not need the .mdb but wanted to see your SQL for the make table query. JeffT said: KARL DEWEY said: Post your SQL. Click to expand... SELECT [Tashman data06].* FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045")); Don't you need the mdb file? Click to expand...
G Guest Oct 25, 2006 #5 KARL DEWEY said: Not need the .mdb but wanted to see your SQL for the make table query. JeffT said: KARL DEWEY said: Post your SQL. : I get an invalid argument msg in make table query but not in select query using exactly the same query. Click to expand... SELECT [Tashman data06].* FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045")); Don't you need the mdb file? Click to expand... Click to expand... SELECT [Tashman data06].* INTO sistersdata FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045"));
KARL DEWEY said: Not need the .mdb but wanted to see your SQL for the make table query. JeffT said: KARL DEWEY said: Post your SQL. : I get an invalid argument msg in make table query but not in select query using exactly the same query. Click to expand... SELECT [Tashman data06].* FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045")); Don't you need the mdb file? Click to expand... Click to expand... SELECT [Tashman data06].* INTO sistersdata FROM [Tashman data06] WHERE ((([Tashman data06].[Code Area])="6045"));