fields average in access

Results 1 to 2 of 2

Thread: fields average in access

  1. #1
    gert Guest

    Default fields average in access

    hulp! I have 3 numeric fields in a record (access database). In the fourth field I want the average of these three other fields. is this possible?

  2. #2
    Join Date
    Dec 1969

    Default RE: fields average in access

    It is possible but not advisable. <BR>Whenever you have a calculated field it is better to use the processing time to calculate it each time rather than the storage space to hold it always.<BR><BR>But the way you do this after the first three fields are filled is:<BR><BR>Update table set field4=(field1+field2+field3)/3 <BR><BR>to update the entire table or <BR><BR>Update table set field4=(field1+field2+field3)/3 where key=value<BR>to update an individual record.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts