One page Summary report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
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
 
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.
 
That might be because your report also calls for a New Page before/after
each group?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
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!!!
 
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.
 
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
 
Back
Top