One page Summary report

[Stockwell43]

Hello,

I hope this request is not difficult but I have a form with a Loan Amount
field. What I am trying to do is, create a report that will show the total
Loan Amount for the chosen date range. Example: Currently, if I pull a report
for May, I have 52 pages and at the end of the report it shows the number of
loans and the total loan amount for all the loans. I want to obtain just the
number of loans and the total Loan Amount for the month to fit on one page
without all the other customer info.

I would greatly appreciate any help and please simplify answer as I not to
sharp on queries.

Thanks!!!!

 

[Jeff Boyce]

One approach might be to set the .Visible property of the Detail section of
your report (in Design View) to "no".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Stockwell43]

I tried that and it works great. However, I still have the same number of
pages they are just all blank except for the last one.

 

[Jeff Boyce]

That might be because your report also calls for a New Page before/after
each group?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Stockwell43]

I found it in help. It had to do with the Section bars which I never knew
before. Great, I just learned something new. Thank you for your help because
until you mention the problem, I would not have looked for it.

Thanks!!!

 

[Stockwell43]

How do I set it so it doesn't call of a new page before and after. I never
set it up that way until it's a default.

 

[Jeff Boyce]

Open in design view. Click on a section bar (Detail Section?). Click on
the Properties button.

Find the property and set it.

Regards

Jeff Boyce
Microsoft Office/Access MVP