Search results for query: *

Hi, my code for DCount is below. =DCount("[Fee Type]","PLL Fee Query","[Fee Type]='No Charge'") When I replace the "PLL Fee Query" with the actual table name rather than the Query name I get a count not the #Error but also not the correct count. Can I...

Thank you, it worked. But I'm still unable to count the number of "No Charge" types. Is there a way to count the "No Charge" types using COUNT rather than DCOUNT? I only want a count of the "No Charge" type. It seems like the DCount formula does not like the...

Hi again, I am now using this field in my Report and need to do a count on this field. I am using the DCount function but am getting #Error. Am I not able to do a DCount on an Expression? My Expr in the query looks like this: Expr1: IIf([FEE_AMOUNT]=5,"Charged","No...

Thank you!!! It worked perfectly.

I am trying to add a new column in my Access query that will display a "Charged" status if the Fee_Amount was $5.00 and a "No Charge" status if the Fee_Amount was $0.00. This should just be an additional column in my query. In Brio I just use Decode but with my lack of...

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

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.

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...

I am attempting to create a similar report but 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 the above formula...