Report Wizard butchering my group hours?

[jkelly295]

I am running the report wizard to create a report that has a grouping level of hours on the right..When the report is previewed the hours are like this

1:00 PM
1:00 pm Meeting 1
1:00 PM
1:25 pm Meeting 2
1:30 pm Meeting 3
1:45 pm Meeting 4

In other words it lists 1:00 twice Once with only the meetings that occured at exactly 1:00 and then again for the ones that are from 1:00 to 2:00

ANy one else had this problem

Thanks

 

[sko]

I was not able to reproduce your problem but I did get a report that looks like this:

1:00 PM
1:00 PM Meeting 1
1:15 PM Meeting 2
2:00 PM
2:00 PM Meeting 3
2:30 PM Meeting 4

My Table contains 2 field, Meeting and Time
I've based my report on a query that contains 3 fields (The time field from my table is pulled in twice. The first time its formatted to show hours only)

Field 1: Hours:format([time],"h:""00"" AM/PM&quot
Sort: Ascending
Field 2: Time
Sort Ascending
Field 3: Meeting

Run the report wizard.
Group by Hour
Add sorting by Time