J
joshbell
Hello,
I am trying to trun some numbers into currency using a calculated value
in a query. Although the result formats the results as currency, it
sorts as a string would. Here is my statement:
Penalty:
IIf([datClaimPaidDate]-[datClaimLtrDate]>30,FormatCurrency(([datClaimPaidDate]-[datClaimLtrDate]-30)*50),"")
Does anyone have any suggestions on how to get this to return as actual
currency that will sort like currency?
Thank you for your help!
jb
I am trying to trun some numbers into currency using a calculated value
in a query. Although the result formats the results as currency, it
sorts as a string would. Here is my statement:
Penalty:
IIf([datClaimPaidDate]-[datClaimLtrDate]>30,FormatCurrency(([datClaimPaidDate]-[datClaimLtrDate]-30)*50),"")
Does anyone have any suggestions on how to get this to return as actual
currency that will sort like currency?
Thank you for your help!
jb