report data grouping failure?

  • Thread starter Thread starter cyberchoc
  • Start date Start date
C

cyberchoc

I have been trying to do a report with three groups (campus,date and time).
date is by month and time is by hour. Campus and date are fine but time is
strange. For example Within the 10AM group I get both 10 and 11 AM data.
Items enclosed in < > are info only and do not appear in report
Get want
<campus> PB PB
<Date> Thursday July 2, 2009 Thursday July 2, 2009
<Time> 10AM 10:55 data record 10AM 10:55 data record
10:58 data record 10:58 data record
11:02 data record Count is 2
<spacer> 11AM 11:02 data record
11:07 data record 11:07 data record
<Group Total> Count is 4 Count is 2

This report is in Access2003 on PC. Don't understand why the spacer or why
the 11AM
data is with the 10AM data
 
cyberchoc said:
I have been trying to do a report with three groups (campus,date and time).
date is by month and time is by hour. Campus and date are fine but time is
strange. For example Within the 10AM group I get both 10 and 11 AM data.
Items enclosed in < > are info only and do not appear in report
Get want
<campus> PB PB
<Date> Thursday July 2, 2009 Thursday July 2, 2009
<Time> 10AM 10:55 data record 10AM 10:55 data record
10:58 data record 10:58 data record
11:02 data record Count is 2
<spacer> 11AM 11:02 data record
11:07 data record 11:07 data record
<Group Total> Count is 4 Count is 2

This report is in Access2003 on PC. Don't understand why the spacer or why
the 11AM
data is with the 10AM data
Click to expand...


Need more details. What are your grouping
fields/expressions? And what record source fields are bound
to the detail text boxes? What is the data type of the
bound fields?

If the time field is the date/time data type, I would expect
the time grouping expression to be =Hour(timefield)
 
Marshall: sorting and grouping
Campus y,n,eachvalue,1,no
originaldate y,y,day,1,no
originaltime y,n,hour,1,no
originaldate n,n,each value,1,no
originaltime n,n,each value,1,no
originaldate n,n,each value,1,no
originaltime n,n,each value,1,no

bound fields: campus,txt
originaldate, d/t with ONLY the date mm/dd/yyyy in field
originaltime, d/t with only the time hh:mm:ss
both of these fields have been seperated (by code) from the full date
on form entry.

In report design
original date header
=format$([originaldate], "dddd,mmm,d yyyy")
original time header
=format$([orginaltime], "h:m")
Detail line
no date or time fields just testing scores for various different tests
 
cyberchoc said:
Marshall: sorting and grouping
Campus y,n,eachvalue,1,no
originaldate y,y,day,1,no
originaltime y,n,hour,1,no
originaldate n,n,each value,1,no
originaltime n,n,each value,1,no
originaldate n,n,each value,1,no
originaltime n,n,each value,1,no

bound fields: campus,txt
originaldate, d/t with ONLY the date mm/dd/yyyy in field
originaltime, d/t with only the time hh:mm:ss
both of these fields have been seperated (by code) from the full date
on form entry.

In report design
original date header
=format$([originaldate], "dddd,mmm,d yyyy")
original time header
=format$([orginaltime], "h:m")
Detail line
no date or time fields just testing scores for various different tests
Click to expand...


Well, I tried to read your posts several times and still
can't make sense of it. You have a group for campus, agroup
for the day (not month) and a group for the hour. Then you
have several sorts on the date and time, only the first time
sort will have an effect (sort them time by minutes). I
don't see how the date sorts and the second time sort can do
anything because the records were sorted earlier in the
list.

OTOH, I also don't see how that can account for an 11 AM
record to be grouped with the 10 AM records unless maybe you
are displaying a different time field than the grouping time
field.

However, your example of the report's output is in two
columns. If the settings for each section's NewRowOrCol
property setting is other than None, it may be confusing
things. I think NewRowOrCol could account for the spacer.

Since I don't have a specific answer for you, I suggest that
you set the report back to 1 column and see what results you
get. If they make sense then, try adding the NewRowOrCol
settings one section at a time and if that's acceptable, set
it to 2 columns. Pay careful attention to the page setup
setting for Down then Across.
 
Back
Top