View button in an update qry

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

Is the "View" button (top left corner of query design-grid
view) of any use in an Update query?

Is it supposed to function as a test before hitting
the "!" button?

It doesn't seem to do much checking.

Thanks!

Regards,
Razor
 
It is there to allow you to change your view of the query from the
query designer to the SQL view, to actually see or edit the SQL for
your query. It is not designed as a test before the execute.

--
HTH

Dale Fye



Hi,

Is the "View" button (top left corner of query design-grid
view) of any use in an Update query?

Is it supposed to function as a test before hitting
the "!" button?

It doesn't seem to do much checking.

Thanks!

Regards,
Razor
 
Dale,
I think it does help to see how MANY records you are about
to update. Am I right?
Razor
 
You must be talking about the datasheet view.

I'd never used this option until you mentioned it, but it does appear
to return the results of the query for a select query, before taking
any action, so you can see what records will be appended, deleted, or
updated.

--
HTH

Dale Fye



Dale,
I think it does help to see how MANY records you are about
to update. Am I right?
Razor
 
Back
Top