Prev: Access 2007 Append Query � Issue with automatically inserted b
Next: Mid string null value
From: Stephengw on 19 May 2010 13:49
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
From: Daryl S on 19 May 2010 14:56
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
 | 
Pages: 1
Prev: Access 2007 Append Query � Issue with automatically inserted b
Next: Mid string null value