in access, round up to nearest fraction(.5)

  • Thread starter Thread starter Stephengw
  • Start date Start date
S

Stephengw

In MS-Access, How do I round a formula result up to the nearest fraction
(Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7
rounds up to 2
 
Stephengw -

Multiply the value by two, then round to no decimal places, then divide by
two.

=Round(2*[YourValue],0)/2
 
Back
Top