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.
Is there some type of add-in for a FLOOR function or a way to write one manually?
Thank you greatly for your help.