Thread: in access, round up to nearest fraction(.5)
View Single Post
  #1  
Old May 19th, 2010, 06:49 PM posted to microsoft.public.access.queries
Stephengw
external usenet poster
  
Posts: 1
Default in access, round up to nearest fraction(.5)
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