Make Table Queries

[seanbolte]

Hello -

Have a file I'm trying to create another table from using Make Table query, and also by trying to filter a selection and then saving out a query from there. What I ultimately need is a table so I can export out.

The error I keep receiving is "invalid arguement" when trying to do this. The file is large once I do my filter, like 4 M records, so I don't know if that is contributing to it. I doubt it since when I do a subset of the filtered group I'm still getting that message.

HELP !!

[garethfx]

Can you try and go through what you initially have there at the moment, I,m a little confused as to whether you have a table already with 4 million records in and need to "make Table" so that you could then append to ?


Gareth

[seanbolte]

The 4M records is a selection from 10M records. I'm getting the errors when to to create the table from there.

Thanks !!

[garethfx]

OK
what criteria are you using to filter out the 4 milliaon records you want in this table as it seems tat what you are putting in for thi is the cause of your problem

[NeoPa]

The error I keep receiving is "invalid arguement" when trying to do this.

Perhaps you could enlighten us as to what you are trying to do when this error occurs?

Tip: Some SQL or VBA code is a must in the answer.