Counting a specific currency record

[AMW1106]

I am trying to calculate a count of a specific dollar amount. My report includes a column of names, a column of account numbers and a column of fees. I need to calculate the number of times a specific fee amount occurred. I used a formula that was suggested in another thread reply but am receiving #Error. I have listed the formula used below. Any suggestions???

=DCount("[Fee Amt]","PLL FEE Qry","[Fee Amt]='$5.00'&quot

 

[BanditWk]

My guess is that your criteria won't find it because you're looking in a Currency field but requesting for String data. Try this:

=DCount("[Fee Amt]","PLL FEE Qry","[Fee Amt]= Format(5,'Currency')&quot

This wasn't tested for whether the Format should be inside the quotes or not...
Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

 

[AMW1106]

Thank you - unfortunately no luck with your suggestion. I am very new to this though so it could be something on my part. Thank you again.

 

[67peshawar294]

amw1106,
Try dcount("[Fee Amt]","PLL FEE Qry","[fee amount] = 5.00&quot.
Use just the 5.00 and not the $ sign.
JP

 

[AMW1106]

Thanks xaf294 - unfortunately, no luck yet. I am getting the same errors. Thanks for your suggestion!