Invalid Query Name

  • Thread starter Thread starter aussie_dave
  • Start date Start date
A

aussie_dave

In Access 2002 I have a simple update query, that sums the
values in certain fields and places the resulting totals
in existing (empty) fields. The query is
called "qryDR723_TSCostsToDate2". When I try to run it I
get an error message telling me it is not a valid name. I
have tried renaming it to many different names, all with
the same error. I cannot see that I have violated any of
the Access naming rules. I have other similarly named
queries that run fine. Can anyine advise me how to fix
this.
 
Hi.
The query is
called "qryDR723_TSCostsToDate2". When I try to run it I
get an error message telling me it is not a valid name.
Click to expand...

Check to ensure that qryDR723_TSCostsToDate2 doesn't contain any invalid
field names, table names, or query names, because the error message may not
be referring to the name of the query, itself.

If you can't find the problem, then make a backup of the database file, then
compact and repair it. Try to run the query again to see whether you still
have the same error message. If you do, then please post the SQL statement,
and we'll take a look at it.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
A couple observations:

First, have you been able to create another query that does the same thing,
naming it "test" or some such, and have it work? If so, perhaps the query
you names "qryDR723_..." is subtly corrupted, and you should throw it out,
replacing with "test".

Second, if you already have "values in certain fields", why do you feel you
need to "place ... totals in ... fields"? There are sometimes genuine
business needs for storing a value that you can calculate, on the fly, in a
query. But these are usually the exception.

JOPO (just one person's opinions)

Jeff Boyce
<Access MVP>
 
Back
Top