Grouping

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Terrington - 30 Jun 2008 07:41 GMT

I have a query that results in the following data

Account No Amount
4110 500.00
4120 600.00
5000 77.00
5300 60.00

I would like to create a grouping that will allow me to specify the grouping
ranges that I require so I end up with

Account No Amount
Income
4110 500.00
4120 600.00
Income Total 1100.00

Expense
5000 77.00
5300 60.00
Expense Total 137.00

I can create groups on preexisting fields, but at a complete loss to figure
out how to specify the group range myself (even if it is possible)??

Thanks in advance.

James

Reply to this Message

TheRealRobbie - 30 Jun 2008 08:39 GMT

Hi James,

You can also, instead of just a fieldname, specify an expression as a group.
Suppose you want split just by the first digit of the salary, you could
first convert to varchar and then take the first character as the grouping
expression.
You can also use case statements, so any group split-up should be possible.

Regards,
Rob

> I have a query that results in the following data
>
[quoted text clipped - 24 lines]
>
> James

Reply to this Message