Repost Reporting Time intervals

  • Thread starter Thread starter Jay
  • Start date Start date
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!!
 
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.
 
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...
 
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
 
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...
 
Back
Top