Recent content by KyleBell

  1. K

    Calculating average of 3. Sometimes 2 out of 3.

    Paul, thank you so much for your help. I'm done with the calculation part of my work and the rest is simple. As a side note, is it possible to do what direptor is asking about? Just something I'm curious about.
  2. K

    Calculating average of 3. Sometimes 2 out of 3.

    I placed the code in a new query under SQL view and it works. It calculates the average of 2 or 3 values correctly. However, the calculated average is not updated on the Average field in my table. How can I do that? In my query's Design View, my "Average" field is Average...
  3. K

    Calculating average of 3. Sometimes 2 out of 3.

    Hi, I'm a newbie and am stuck with doing somebody else's work that they did not finish before leaving. Anyway, I have three columns named [Staff], [Student] and [Peers]. I need to grab the values from those three fields and calculate the average value. Normally, I'd use...
Back
Top Bottom