Rounding Time

[nknigi]

I have a report that uses the Format$ function. I'm trying to find out how many items are processed by the hour. When it breaks it down it is rounding up the time. 5:00 - 5:29 are showing under 5:00 but 5:30-5:59 are showing as 6:00. How can I get it to round down so 5:00-5:50 reports as 5:00. I'm using =Format$([entryTime], "h ampm",0,0) I can't find much help for the Format$ function.

[jzwp11]

What is the datatype of the entryTime field?

[jzwp11]

I'll assume that your entrytime field is a date/time datatype, please correct me if I am wrong.

In Access dates and times are not stored as you typically see them. They are stored as a number with the portion of the number to the left of the decimal point as the number of days since 12/31/1899. The portion of the number to the right of the decimal point holds the time as a fraction of a day. So 1/9/2011 12:00:00 PM is stored as 40917.5 (my date is mm/dd/yyyy).

In terms of your report issue, you will have to convert the fraction of a day into something you can group by. The following expression should return the integer hour portion of the time. I used the timevalue() function to strip off the date portion assuming that your field had both date and time.

INT(timevalue(EntryTime)*24)