Let me back up to the beginning.
My query checks the data for specific records like closed- FirstOne:
IIF......[closed]=1,1,0)
Question "Why am I doing a sort"
All I want to do is sum these in a text box on the report =Sum([FirstOne])
That is why I add the sort. When I add the sort and place the sum function
in the sort footer I get the correct sum, but I also get extra blank pages.
Question "Why does my source have more than one total"
THe source is just the query which does not have totals. I'm trying to show
totals of a few fields on the report, which it does fine with the sort, but I
get multi blank pages.
Hope this helps.
Duane Hookom said:
If all you want to see is one row of sums, why are you doing any sorting and
why does your report record source have any more than one totals row?
Help me out here, what is the record source of your report and what do you
expect to display in the report?
A crude solution might be to make the detail and all group sections
invisible and display your totals only in the Report Header or Footer section.
--
Duane Hookom
Microsoft Access MVP
Dan @BCBS said:
I never mentioned anything about details!!
I'm not getting details and I don't want to. I just don't want the extra
blank pages.
All I'm trying to do is show three sums in a text boxs on the report.
The sum works fine, but I get two blank pages, I asusm it's because the
report is sorted and there are three veriables in the sort..
:
It seems that you could create a totals query to base your report on since
you don't want to see details.
--
Duane Hookom
Microsoft Access MVP
:
I made a report from a query.
The report is sorted.
On the report I ask have three text boxes that ask for a total.
=Sum([One]), =Sum([Two]), =Sum([Three])
My problem is that the first two pages are blank then the third page has my
totals.
AND the totals are written three times each on the third page.
All I want is one page showing a total for the three sums.
What am I missing?
