[AccessD] calculation

Dan Waters dwaters at usinternet.com
Mon Jul 13 09:19:06 CDT 2009


Pedro,

Can you post your equation?  I can't see how to get 25%.

Also - what is B3?

Dan

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




More information about the AccessD mailing list