A couple questions

  • Thread starter Thread starter jsd
  • Start date Start date
J

jsd

I'm working in design view of a brand new report. I've
come across a couple problems that I need some help with.
Any help is appreciated.

1. How do you underline the last line of information in a
group in the details header in design view? For example
Smith
Jones
Young (underline Young)

and

2. How do you get the grand total in a long list of
numbers. Is this done is design view or do I have to open
a new header/footer?

oh and 1 more...

3. In my report, in the top right hand corner, I'd like to
list the customer numbers that are displayed within the
report(for filing reasons). I want it to look something
like this...

customer number 1, 5, 10, 14

Thanks to anyone who can help.
 
I'm working in design view of a brand new report. I've
come across a couple problems that I need some help with.
Any help is appreciated.

1. How do you underline the last line of information in a
group in the details header in design view? For example
Smith
Jones
Young (underline Young)
Click to expand...

The simplest way would be to just put a line control at the top of the
section footer.
and

2. How do you get the grand total in a long list of
numbers. Is this done is design view or do I have to open
a new header/footer?
Click to expand...

New footer.
oh and 1 more...

3. In my report, in the top right hand corner, I'd like to
list the customer numbers that are displayed within the
report(for filing reasons). I want it to look something
like this...

customer number 1, 5, 10, 14
Click to expand...

This will take some VBA code - you'll need to loop through the
Report's Recordsource building up a text string. Would this be all the
customers on this *page*, or all on this *report* (and the report
could concievably run to hundreds of pages)?
 
Back
Top