Query help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darryl - 31 Aug 2005 16:49 GMT

I have a table with transactions in it. Here is a rough layout:

trnum, trdate, ttype

Say their are 100 transactions between 7/01/05 and 7/31/05. I need a report
where is shows the transactions grouped by transaction type (ttype) and at
the
end of the report something like:

100 new transactions 10% type withdrawl 20% type transfer, etc.

Now I have some ulgy stuff latched together to do something close.

Is there a clean way to do this ?

thanks.

Reply to this Message

Chaim - 31 Aug 2005 18:54 GMT

The summary line should be creatable using a query along the lines of:

SELECT (Select count(*) from [Your Table]) as [Total Transactions], ttype,
format(count(ttype)/(select count(*) from [Your Table]),
"PerCent") as [Per Cent Breakdown]
FROM [Your Table]
group by ttype;

This gives you the total number of transactions, the type of transactions
and the percentage of the total. It does not give you this information as a
single line summary.

--

Chaim

> I have a table with transactions in it. Here is a rough layout:
>
[quoted text clipped - 12 lines]
>
> thanks.

Reply to this Message