RE: Multi pages

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" wrote:

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" wrote:

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..


"Duane Hookom" wrote:

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


"Dan @BCBS" wrote:

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?
.

Relevant Pages

  • Re: Report is making too many numbers
    ... My report is grouped by Vendor, then Project, ... source query before putting it in the report so every record shows). ... A Running Sum text box accumlates its total. ... I've got a problem with Sum Totals at the end of a report, ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... A Running Sum text box accumlates its total. ... records--you could create a Totals query by depressing the Total ...
    (microsoft.public.access.reports)
  • RE: How to add a total from three other sums in a report
    ... Sometimes the report totals each record correctly sometimes not. ... "Jeff C" wrote: ... However the NZ sum of all three text boxes is adding correctly. ...
    (microsoft.public.access.reports)
  • Re: Report is making too many numbers
    ... from the $'s being listed more than once in the query. ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... those records--you could create a Totals query by depressing the ...
    (microsoft.public.access.reports)
  • Re: Sorting Dates
    ... dates to sort properly. ... and grouping expressions used in your report design view. ... Select the overtime hours totals field and Descinding order That is if you ... Then below that select the 'seniority ...
    (microsoft.public.access.reports)