Calculating in reports

[Guest]

I have a report which shows all referral souces and the number of referrals
we have received from each of their departments.

What I want to do is show the percentage of referrals coming from every
department and then at the end of each hospital I'd like to include totals
for that hospital. Then at the end of the report i'd like a grand total.
Example

John Hospital

Department Referrals % of Total
(I want to create this colum)
Wards 10 5%
A&E 20 10%

Total 30 15% (I want to creat this row)

I usually use the summary option for this sort of stuff but for some reason
when I uesd that it kept leaving the departmental names out.

I'd be very grateful for some advice thanks very much

Ian

 

[MA]

I have a report which shows all referral souces and the number of
referrals we have received from each of their departments.

What I want to do is show the percentage of referrals coming from
every department and then at the end of each hospital I'd like to
include totals for that hospital. Then at the end of the report i'd
like a grand total. Example

John Hospital

Department Referrals % of Total
(I want to create this
colum) Wards 10 5%
A&E 20 10%

Total 30 15% (I want to creat
this row)

I usually use the summary option for this sort of stuff but for some
reason when I uesd that it kept leaving the departmental names out.

I'd be very grateful for some advice thanks very much

Ian

Create a field of total for each row
10 30
20 30

then it's to calculate for percentula in fron t of total.


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it

 

[Guest]

Sorry I'm a bit of a novice with Access how do I go about doing that?

 

[MA]

Sorry I'm a bit of a novice with Access how do I go about doing that?

Create a calulated field by dsum("Referral","Youtable")


--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa - Conferenza Italiana per Sviluppatori Access
Info: www.donkarl.com/it