• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2599
  • Last Modified:

FLOOR function alternatives in Access 2000

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
bickerrn
Asked:
bickerrn
  • 2
1 Solution
 
MoliereCommented:
Try this:
=INT(Number*2+.5)/2
0
 
BernardHCommented:
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
 
BernardHCommented:
Sorry, my formula is not correct. Read
Rdot5= Round(Nb*2)/2
B.
0
 
bickerrnAuthor Commented:
Almost too easy.
This is just what I needed.
Many Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now