[AccessD] calculation

Pedro:

Shouldn't AA % be 87.5 (total of 7 for AA of the total of 8 for all
patients)?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: Monday, July 13, 2009 3:55 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] calculation

Hello Group,

i need to calculate the percentage(%) of the value B3 in access for the
total of numbers of B.

The table that is have:

ID    patient    B
1     AA         1
2     AA         1
3     AA         2
4     AA         3
5     BB         1


Query:

patient    B(%)
AA         25

How can i do this?

Thanks

Pedro


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com