?
Solved

FLOOR function alternatives in Access 2000

Posted on 2003-03-31
4
Medium Priority
?
2,438 Views
Last Modified: 2012-05-04
I am attempting to group a particular field of data into increments smaller than an integer. I have been using the FLOOR function in Excel (=FLOOR(Number,0.5)), but wish to implement the procedure in Access. As you know, the ROUND() function does not deal with decimals. I need the data seperated in .5 unit increments. Here is an example of the data I have and the conversion I need to occur.

Given:     Needed:

3.0        3.0
3.2        3.0
3.4        3.5
3.8        4.0
4.0        4.0

Is there some type of add-in for a FLOOR function or a way to write one manually?

Thank you greatly for your help.
0
Comment
Question by:bickerrn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
Moliere earned 2000 total points
ID: 8241271
Try this:
=INT(Number*2+.5)/2
0
 

Expert Comment

by:BernardH
ID: 8241323
I think the solution is in your sentence...

You said that the rounded function deals with integer so you can create a function:

Rdot5 = (Nb * 2) / 2.

Good fun
Bernard
0
 

Expert Comment

by:BernardH
ID: 8241334
Sorry, my formula is not correct. Read
Rdot5= Round(Nb*2)/2
B.
0
 

Author Comment

by:bickerrn
ID: 8241535
Almost too easy.
This is just what I needed.
Many Thanks.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question