Text Box Calculations and Number of Pages

[Moose222]

I am trying to make a output where (=-sum([GCFLAG]="C&quot.
The answer to this is about 225. When I insert a Text box
the answer is displayed on 76 pages.

How can I get the answer to display on just 1 page?

Thanks in advance.

Jim Nelson
.

 

[bethabernathy]

Hi - If I am understanding you, what you need to do is add the control/text box in the report footer and then it will display on the last page of the report.

Let me know if this works? Beth

 

[Moose222]

Beth,

Thanks for your reply. I should have made this clear in the beginning. I am using Access 2000. I have a column that is labeled GCFLAG, in this column there are lets say 300 entries, 225 with the letter "G" and 75 with the letter "C".

I am trying to print out a report that is only one page where I can show the total # of G's and C's and a Total of both G and C. Thus far I have tried using DCount and DSum, both seem to work ok.

I used the following formula's:

For Total G: =-SUM([GCFLAG]="G&quot
For Total C: =-SUM([GCFLAG]="C&quot
For Total of Both: =-SUM(([GCFLAG]="G&quot OR ([GCFLAG]="C&quot)

I have tried putting these in the header, footer and details section but I seem to be getting up to 76 pages of info with the totals on each and every page.

I know this is something silly, but I would appreciate any help!!!

Thanks,
Jim

 

[bethabernathy]

Hi Jim: If you want you can zip up your database and email it to me at:

beth@integratedresourcemgmt.com

I can take a look at it. It might be easier and quicker that way.

Beth

 

[CosmoKramer]

Jim,

If you're only looking for totals, create your report so there is no detail section. In your report footer put text boxes something like this:

=DCount("[GCFLAG]","YourTable","[GCFLAG] = "G")

=DCount("[GCFLAG]","YourTable","[GCFLAG] = "C")

and if they all contain one or the other...

=DCount("[GCFLAG]","YourTable")

 

[Moose222]

This seems to have worked. How can I write a report without a details section? I have tried everything to delete it but NOGO.

Thanks,
Jim Nelson

 

[CosmoKramer]

If the detail section is empty, you can drag the top of the section below the detail section up (when the cursor becomes the "Horizontal Resize" one.....

 

[Moose222]

Cosmo,

Thanks for your help, I have moved the footer section directly under the details section, and have moved the details section directly under the header section.

The problem is that I am still left with about 15 blank lines in the report.

Thanks for all your help, it is very much appreciated.

Jim Nelson