Grouping Time

[Ian]

I'm trying to group a time field (already have it grouped by date) but can't
convert the time field into time. I've set the format to MedTime but the
ControlSource reads:

=Format$([ApptStart],"mmmm yyyy",0,0)

What do I put for MedTime?

Thx.

 

[Allen Browne]

If ApptStart is a date/time field that contains the date and the time, you
can use the Sorting And Grouping in report design to do the grouping.

Select the field in the Sorting And Grouping box. Provided Access recognises
it as a date/time field you can group by hour (or day, or month, or year, or
....)

 

[Duane Hookom]

So, you have a time field that isn't a time but you want to group it by
MedTime. I'm confused. Do you want to sort/group by minute or second or hour?
Does ApptStart contain both the date and time?