Thread: in access, round up to nearest fraction(.5)
View Single Post
  #2  
Old May 19th, 2010, 07:56 PM posted to microsoft.public.access.queries
Daryl S[_2_]
external usenet poster
  
Posts: 881
Default in access, round up to nearest fraction(.5)
Stephengw -

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

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

--
Daryl S


"Stephengw" wrote:

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