Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Calculation Problems

    I am trying to use

    Expr1: DCount("[LOA/NLOA]","Mailing List","[LOA/NLOA] = 'LOA'")

    to calculate the number of loa records in the LOA/NLOA field. I have another field called FY that I also need to be able to restrict the equation to so it will only calcuate the LOA by the Fiscal Year in the FY field. Ie would FY=04. I would need the LOA/NLOA to count the LOA's but only for FY=04 not all the LOA's in the table.
    Can anyone let me know how I can add Fy restrictions to that formula.
    Thanks in advance for your help.

    Cory M Greenwell

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    You can use AND to tack on criteria as necessary.


    Expr1: DCount("[LOA/NLOA]","Mailing List","[LOA/NLOA] = 'LOA' AND FY=04")

Posting Permissions

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