S
Slez via AccessMonster.com
I'm developing a report that I want to display quarterly totals on. I first
created the report to include all of the records, along with some calculated
controls. When I go to Sorting and Grouping and change the [BidDate] field's
Group On property to "Qtr", the calculated controls in some cases return
incorrect totals. I can't figure out how it is arriving at the incorrect
totals. Are there any specific things to watch for when setting that
property to "Qtr"? I've never tried this property setting before.
Here is how my report is currently structured:
BidDate group
Estimator group
BidNumber group (contains the BidDate control)
Detail
It doesn't matter where BidDate falls in Sorting and Grouping and whether or
not there is a header/footer. As soon as I change the Group On property to
"Qtr", it alters my totals.
Any suggestions are appreciated! Thanks!
created the report to include all of the records, along with some calculated
controls. When I go to Sorting and Grouping and change the [BidDate] field's
Group On property to "Qtr", the calculated controls in some cases return
incorrect totals. I can't figure out how it is arriving at the incorrect
totals. Are there any specific things to watch for when setting that
property to "Qtr"? I've never tried this property setting before.
Here is how my report is currently structured:
BidDate group
Estimator group
BidNumber group (contains the BidDate control)
Detail
It doesn't matter where BidDate falls in Sorting and Grouping and whether or
not there is a header/footer. As soon as I change the Group On property to
"Qtr", it alters my totals.
Any suggestions are appreciated! Thanks!