Update Query Data Sheet View Question

[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

 

[Duane Hookom]

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.

 

[John Spencer (MVP)]

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).