Queries and data protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a query and I would like to know how I can protect certain
displayed data fields within that query from update. I retrieve names from
my database and my query will allow others to change the names. Some fields
I want them to be able to change, others not. How do I prevent this.

I am a novice at Access.
 
Duane, that worked great! Is there a way I can add a calculation to the
form. What I need to do is average 5 values found in my table and display
them on the form?
 
You can average a field by adding a text box in your form footer with a
control source like:
=Avg([Your Field Name])
This works unless your table isn't normalized and you need to average across
multiple fields.
 
Back
Top