Make Table query not-so-wizardly - most frustrating!

[klf]

I have used the query wizard to create a simple unmatched select query which
runs wonderfully and returns the expected 51,000 records. When I use the
same criteria, or try to switch it to a 'make table' query for export, I get
"invalid argument". New to SQL, but the code *looks* okay to me:

SELECT TEST.ID, TEST.PHONENUM, TEST.ORIGFULLAD, TEST.ORIGFULLST,
TEST.ADDRNUM, TEST.COMMUNITY, TEST.COUNTY, TEST.STATE, INTO New_Tbl
FROM TEST LEFT JOIN Old_tbl ON TEST.ID = Old_tbl.ID
WHERE (((Old_tbl.ID) Is Null));

Any suggestions would be appreciated!

 

[Gary Walter]

get rid of comma after TEST.STATE?

 

[John W. Vinson]

I have used the query wizard to create a simple unmatched select query which
runs wonderfully and returns the expected 51,000 records. When I use the
same criteria, or try to switch it to a 'make table' query for export, I get
"invalid argument". New to SQL, but the code *looks* okay to me:

You've got an extra comma in front of the Into.

HOWEVER... what makes you think you need a MakeTable at all? YOu can export
the query itself; no need to take the extra step!

 

[klf]

My bad, folks - the extra comma is not in the query, I was truncating for
simplicity and missed deleting it.

But I must admit to an embarrassed revelation about exporting the query -
had tried right-clicking on the datasheet view but on not the 'Queries'
button...

Still am puzzled what argument is invalid for a make table query, but not
select - can see no logical difference b/t them except the make table syntax.

Anyway, thank you for your prompt replies. Learn something every day!