By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Summarize Text

P: n/a
Is there a way to summarize text in a report section footer, almost the
equivalent of =Sum(Quantity) for text.

One order can contain multiple line items of either the same product or
of several different products. In my report the detail is set to
invisible with the section footer showing only the total quantity for
that order plus the product or (if possible) products that make up that
total.
Any ideas?

Thanks for your help

Chris

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Reports CAN do all this.

To print the quantity total, you must first convert the "number" into either
an integer (no decimals required) or a single (now tell it how many decimal
points you want). In this case, your best option is the integer. A function
exists that performs this conversion for you. Check the help system for it -
the exercise has the potential of helping you become familiar with all of
them.

Look into sub-reports as a way to provide the rest of what you want to do.
Again - the help system needs to become your best friend.

Hope this helps - Good Luck

<ch**********@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Is there a way to summarize text in a report section footer, almost the
equivalent of =Sum(Quantity) for text.

One order can contain multiple line items of either the same product or
of several different products. In my report the detail is set to
invisible with the section footer showing only the total quantity for
that order plus the product or (if possible) products that make up that
total.
Any ideas?

Thanks for your help

Chris

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.