[AccessD] calculation

Something like...

Select ID,Patient, B, Sum(b) as bTotals, B/bTotals as b_Percent from SomeTable; 

???

Lambert

-----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 11:55 AM
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