Grouping on a report

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

Guest

Hi
I have a report that shows the orders and it's values; How to group them; I
have tried the group header and fotter option; but the interval is not the
way i need.I am looking for the following

Fields in my reports are
Order number
Order amount
I need my report to show Order amount $0 to $500 - No of orders and it's
value
$501 to $2000 No
of orders and it's value
$2001 to $5000
No of orders and it's value
$5001 to $10000
No of orders and it's value
and 10,001 no
orders and it's value

Can anyone help pls
 
Hopefully your report is based on a query, not on a table. If not, create a
query that has all of the necessary fields in it, and add a computed field
that returns the appropriate range each row (You can create a public
function in a module to do this, or you can use nested IIf statements or you
can use the Switch function)

In the report, indicate to use this computed field in the Sorting and
Grouping box.
 
Back
Top