D
dauster
I have a report based on a parameter query. Without any grouping, all rows
from query display correctly with 3 fields - area description, number of
people for that area, and amount raised for that area. When, I add a grouping
on the report for a date field all 3 fields stills display the correct data
from query. I then add in the group footer, 2 text box fields that will sum
up the number of people for that area and the amount raised for that area.
However, the data displays incorrectly. For the last date group, the last
record in the detail section will display the area description but the number
of people will be zero and the amount raised will be zero. If I remove one of
the sum fields from the footer the correct data will be displayed for that
last record. Any suggestions? I am not using a running sum on those 2 fields.
from query display correctly with 3 fields - area description, number of
people for that area, and amount raised for that area. When, I add a grouping
on the report for a date field all 3 fields stills display the correct data
from query. I then add in the group footer, 2 text box fields that will sum
up the number of people for that area and the amount raised for that area.
However, the data displays incorrectly. For the last date group, the last
record in the detail section will display the area description but the number
of people will be zero and the amount raised will be zero. If I remove one of
the sum fields from the footer the correct data will be displayed for that
last record. Any suggestions? I am not using a running sum on those 2 fields.