Repost Reporting Time intervals

J

Jay

I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!
 
D

Duane Hookom

Did you try the solution that I suggested in my reply yesterday? If so, did
it work? If it didn't work, please provide more information.
 
J

Jay

Yes I did try the formula you gave however it only showed
as 12:00 AM on the report.
-----Original Message-----
Did you try the solution that I suggested in my reply yesterday? If so, did
it work? If it didn't work, please provide more information.

--
Duane Hookom
MS Access MVP
--

I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!
Click to expand...


.
Click to expand...
 
F

Fons Ponsioen

Try this formula.
Val(Hour([Time]))+(Int((Minute([Time])+14)/15)/4)
You may want to adjust the 14 and 15 above to adjust for
the rounding you wish to employ.
By the way "Time" is an Access function name, I would
recommend to give this variable some other name.
Hope this helps
 
D

Duane Hookom

Setting up your sorting and grouping will not show you anything on the
report. It will only set your sorting and grouping.

--
Duane Hookom
MS Access MVP


Jay said:
Yes I did try the formula you gave however it only showed
as 12:00 AM on the report.
-----Original Message-----
Did you try the solution that I suggested in my reply yesterday? If so, did
it work? If it didn't work, please provide more information.

--
Duane Hookom
MS Access MVP
--

I am trying to run a report that shows time intervals of
1/2 hour and 15 minute increments right now on the report
the time field looks like this:
=Format$([Time],"h ampm",0,0)
Currently the report breaks the time in hour increments.
Thanks in advance!!
Click to expand...


.
Click to expand...
Click to expand...
 
Top