Saving query after viewed

[Jeff]

After I have run a query and have updated any fields in the database that
needed to be corrected is there a way to save it as a table rather re-running
the query.

Also I have a checkbox field - is there a way to select all in the feild and
mark the checkbox in the so as the records are updated in the query the
master database which has the same field will they get marked as well.

Finally if you delete a record in a query will it get deleted in the main
database.

I appreciate your kind assistance

 

[Gina Whipp]

Jeff,

Not quite sure I understand what you are trying to do... Should you save
the query as a table, just use a make table query, then you won't have
'fresh' results of the query when you go run and update your fields in the
table/s included in the query. The data in the table you created will
always reflect the old information.

For the checkbox I would suggest creating an update query if you are looking
at doind a mass change to a Yes/No field.

Deleting a record in the query does delete it in the underlining table.
Remember, the query is just a 'question' you are asking of the table.

You might want to take a look at http://www.accessmvp.com/strive4peace/ by
Crystal Long. It might give you a better understanding of tables and
queries and how they relate to each other.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm