Rounding 1

[hollyann]

Really need help!  This must be a tough one because I cannot get the answer anywhere.  I need 8 expressions in a query to round to the nearest 50 cents.

 

[JimHorton]

hollyann,<br>You need to be a little more specific...but as a general answer, if you have a field,AMT.&nbsp;&nbsp;Put this in a query expression field:<br>Rounded: Int([AMT])+Switch([AMT]-Int([AMT]) Between 0 And 0.24,0,[AMT]-Int([AMT]) Between 0.25 And 0.74,0.5,[AMT]-Int([AMT]) Between 0.75 And 0.99,1)<br><br>This assumes that if the amount is 1.26, you want 1.50, 1.24=1.00, 1.74=1.50, 1.75 = 2.00 etc.<br>--Jim

 

[hollyann]

Thank you so much!!&nbsp;&nbsp;That is exactly what I needed and it works perfect.&nbsp;&nbsp;I wish I had gotten on this forum and asked this question about 2 weeks ago- it would have saved me many headaches.