Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Average Positive Return (2000)

    Hello,

    I have a form which lists the net returns for 4 mutual funds at one time. The data is put into a temporary table from 4 update queries and then is used for the purpose of this form.

    The bottom of this form then gives various calculations on each of the 4 funds. A couple of the calculations I need to add to this form are 1) average positive return and 2) average negative return. The definition of an average positive return: the total of the positive net returns divided by the positive number of months.

    Does anyone know how to do this on a form?

    TIA

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Average Positive Return (2000)

    How would you do it on a spreadsheet?

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Average Positive Return (2000)

    Use the DSum command.

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Average Positive Return (2000)

    Thank you - it works like a charm.

Posting Permissions

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