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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Round to Nearest Integer in Access	=?Utf-8?B?UmVuZWU=?=	Microsoft Access Queries	8	14th Nov 2008 12:25 AM
Don't want Access to round numbers to nearest integer.	=?Utf-8?B?QWFyb24=?=	Microsoft Access Forms	1	16th Mar 2007 03:28 PM
calc # of d, m, y, then round to nearest fraction	=?Utf-8?B?UnVieQ==?=	Microsoft Excel Worksheet Functions	2	25th Jul 2006 01:41 PM
round a value in access to nearest thousand	=?Utf-8?B?Q2F0aHk=?=	Microsoft Access Database Table Design	2	3rd Dec 2004 08:45 AM
Is there a way to round to the nearest fraction (not 10th, 100th,.	=?Utf-8?B?RGF2ZSBP?=	Microsoft Excel Worksheet Functions	7	2nd Oct 2004 01:40 PM