Results 1 to 2 of 2
  1. 06-17-2009, 07:35 AM #1
    BravoEcho
    BravoEcho is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2009
    Posts
    2

    Conditioned Average

    Hi!



    I have encountered a problem and i don't know how to solve it. A little help maybe...please.

    I have a Querry that is named "Average" which contains the fields MARK1, MARK2, MARK3, MARK4, MARK5 and the field AVGMARK. I want to calculate the average between MARK1...MARK5 in AVGMARK, but these fields can all be populated (5) or 4, or 3, and so on, but minimum 1 field (at least one field must be populated).

    Hope you can help. Thank you!
    Reply With Quote Reply With Quote
  2. 06-17-2009, 09:38 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I think you will need a User Defined Function (UDF) for this. Welcome to the wonderful world of VBA code.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. 7 day average and total
    By jannie in forum Access
    Replies: 1
    Last Post: 05-14-2009, 05:52 PM
  2. Select query for Exponential Moving Average.
    By krishna79 in forum Queries
    Replies: 0
    Last Post: 01-22-2009, 05:52 AM
  3. Newbie Needs help with combine/average
    By wfd1753 in forum Queries
    Replies: 2
    Last Post: 05-16-2008, 06:43 AM
  4. Weighted Average - Challenges
    By edmund_xue in forum Access
    Replies: 0
    Last Post: 04-02-2008, 12:54 AM
  5. Get average of unbound textboxes.
    By markhook in forum Forms
    Replies: 8
    Last Post: 07-14-2006, 09:30 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums