Return Number In Calculated Field as Currency

  • Thread starter Thread starter joshbell
  • Start date Start date
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(([datClaimPaidDa­te]-[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
 
Don't create an IIf() calculation that might return a number of might return
a string.
Penalty:
Val(IIf([datClaimPaidDate]-[datClaimLtrDate]>30,([datClaimPaidDa­te]-[datClaimLtrDate]-30)*50,0)
You can apply a format in a control on your form or report.
--
Duane Hookom
MS Access MVP
--

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(([datClaimPaidDa­te]-[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
 
Back
Top