Queries and data protection

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

 

[Guest]

Create a form to display your query and disable/lock some text boxes.

 

[Guest]

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?

 

[Guest]

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.