Query help

D

Darryl

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.
 
C

Chaim

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.
 
Top