Query will run but error msg on Save

[Matilda]

Hi All,

I am getting constant error messages on Save ("Invalid Argument") in query
design mode, but the query runs without problem. I have tried removing fields
one by one, reconstructing the query field by field (there is only one table
- I want to create a new table using only some of the fields of the original
table).

Please help. The table contains approx 900,000 records.

MTIA

Matilda

 

[John W. Vinson/MVP]

Please open the query in SQL view and post it here.

 

[Matilda]

Hi John,

Thanks for your prompt response.
Actually, I found another question on the website with a similar problem
that I hadn't found with an earlier search, and tried that solution and it
worked. For the benefit of others who might read this, the problem did seem
to be one of overflow (900,000 rows). The advice was to compact and repair
the database, then open a blank database and link to the source table, and
try again. I lost my work on my query (which had a few calculated fiels and
expressions) but it was worth it to get going again.

Again, thanks. You guys are just marvellous.

Matilda