Grouping with Intervals

R

Rebekah

Attempting to create a report that groups and sorts on EntryDate. Also only
want 25 records at a time in each grouping sequence. For the first date
sequence, it starts working properly but for each date thereafter, it starts
breaking it up by additional groups.

How it looks:

2/8/06
rrr 50
wer 50
Sum 100
2/10/06
sdf 25
Sum 25
2/10/06
sfd 35
Sum 35
2/14/06
jkl 75
jkl 125
Sum 200
2/14/06
ytu 175
ytu 35
Sum 210

How I want it to look:

Entry Date Entered By Amount
2/8/06
rrr 50
wer 50
Sum 100
2/10/06
sdf 25
sfd 35
Sum 60
2/14/06
jkl 75
jkl 125
ytu 175
ytu 35
Sum 410

How grouping and sorting is currently setup (and I've tried multiple
reconfigurations and I have got to be missing something right in front of my
nose because I have another report where I don't have any issues and I am
doing the exact same thing...go figure).

Group
EntryDate Ascending
Group Header Yes
Group Footer Yes
Group on Each Value
Group Interval 25
Keep Together No

Sort EnteredBy Ascending

Any help would be appreciated.

Thanks,
Rebekah
 
M

Marshall Barton

Rebekah said:
Attempting to create a report that groups and sorts on EntryDate. Also only
want 25 records at a time in each grouping sequence. For the first date
sequence, it starts working properly but for each date thereafter, it starts
breaking it up by additional groups.

How it looks:

2/8/06
rrr 50
wer 50
Sum 100
2/10/06
sdf 25
Sum 25
2/10/06
sfd 35
Sum 35
2/14/06
jkl 75
jkl 125
Sum 200
2/14/06
ytu 175
ytu 35
Sum 210

How I want it to look:

Entry Date Entered By Amount
2/8/06
rrr 50
wer 50
Sum 100
2/10/06
sdf 25
sfd 35
Sum 60
2/14/06
jkl 75
jkl 125
ytu 175
ytu 35
Sum 410

How grouping and sorting is currently setup (and I've tried multiple
reconfigurations and I have got to be missing something right in front of my
nose because I have another report where I don't have any issues and I am
doing the exact same thing...go figure).

Group
EntryDate Ascending
Group Header Yes
Group Footer Yes
Group on Each Value
Group Interval 25
Keep Together No

Sort EnteredBy Ascending


Check the date values in the table, it looks like they may
have their time part set.

If you really want the time part of the date field in the
table, then group on the expression:

=DateValue(EntryDate)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top