Update Query

  • Thread starter Thread starter cna48
  • Start date Start date
C

cna48

I have an update query that is base off of another query. When I run the
update query it only changes the data in the regular query, but not in the
table. Am I missing something simple.
 
An update query updates fields in tables. It does not change the data in
another query, it can't. Select queries show the data from the table.

Are you executing the query (Query: Run) or are you just switching to
datasheet view? Just switching an update query to datasheet view does not run
the update. It should just show you which records will be updated when you
RUN the query.

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