Update To Formulas Gone

[Rookie Access User]

I was building an update query to update or populate a number of fields when,
for some reason, my update formulas dissappeared. I saved the query a few
times during the process. I would enter the "update to" formula, run the
query and then review the results. Sometimes I would review the results in
the affected table and sometimes I would review the results by temporarily
changing the update query to a select query.

I could have sworn that the update formulas remained unless you delete them.
But I'm thinking maybe I saved the query while it was in the select query
mode and thereby lost my update formulas. If this is the case, is there a
way or some setting so the formulas are not erased? Any other theories as to
why my carefully written and tested update formulas dissappeared?

 

[Rookie Access User]

Now what? I just closed and reopened my update query and, with the exception
of those fields with update formulas, all the fields I had added to the query
were gone. Before just the formulas dissappeared, not the fields.

 

[Rookie Access User]

Yikes! I partially rebuilt the query by just adding the fields back in.
Before taking the time to add in the additional update formulas I wanted to
check what would happen if I closed and opened the query. Sure enough, all
the fields I just added were gone again. Help!

 

[John Spencer]

If the fields are not being updated and do not have any criteria applied
against them, then they are not needed by the update query and are removed.

You can see something similiar if you create a select query and add some
fields and then uncheck Show. Unless the fields are being displayed, or are
used to order the records, or are used to filter the records they are not
being used in the query and are removed.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County