Update Query Data Sheet View Question

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Why does an update query's data sheet view sometimes show something
different than the results it produces when you run it?

Yesterday I had an update query that produced the intended changes in
the target table. However, when I previewed it in data sheet view, it
listed each record with a zero in every cell (when I ran the update
query it obviously put numbers like 1, 2, 3, etc. in the table).

I was in a hurry ... so I didn't save the query. This is something
that happens to me every once in a while ... I can see if I can repeat
it if there's not a clear general explaination.

Thanks, Mark
 
An update query will always show you the current records in the datasheet
view. It will only show the updated values after the update query has been
run.
 
Or to put it another way, the data sheet view shows you which records you have
selected to update and their current values for the fields you are going to
update. Once you have updated, the values will be changed (at least we hope
they will be).
 
Back
Top