Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    count only 0.00 (2000)

    This is the formual that I have Count([FEE_1]+[FEE_2]+[FEE_3]+[FEE_4]+[FEE_5])=("0.00")...I know this is not correct so, can someone give me the correct formual.. Or any other suggestions. I need to count all the 0.00 this is a number format.

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: count only 0.00 (2000)

    Base a new query on a table named "tbl_Fees" with an ID field and the 5 Fee fields you mention in your original post. Bring the ID field into the query grid, and in the next column in the grid add each of the fee fields together and call that new field "Sum". In the Criteria row for "Sum", type 0. Turn this into a Totals or Group By query, grouping on your new "Sum" field, and counting your ID field. The SQL would look like the below. Best of luck!

    SELECT Count(tbl_Fees.ID) AS CountOfID, [Fee_1]+[Fee_2]+[Fee_3]+[Fee_4]+[Fee_5] AS [Sum]
    FROM tbl_Fees
    GROUP BY [Fee_1]+[Fee_2]+[Fee_3]+[Fee_4]+[Fee_5]
    HAVING ((([Fee_1]+[Fee_2]+[Fee_3]+[Fee_4]+[Fee_5])=0));
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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