[AccessD] calculation

Hello Rocky,

yes, for each patient the percent of the total number of tests scored a 3.
The query Lambert gave, doesn't work.

Thanks

Pedro



----- Original Message ----- 
From: "Rocky Smolin" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, July 13, 2009 4:58 PM
Subject: Re: [AccessD] calculation


> OIC.  You want to know for each patient what percent of the total number 
> of
> tests scored a 3?
>
> Rocky
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
> Sent: Monday, July 13, 2009 7:45 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] calculation
>
> Hello Dan, and others.
>
> i haven't got an query equation jet,
> i can't seem to manage the group by calculation.
>
> How i get 25%
>
> Patient AA has 4  test (ID 1 to 4)
> One of these has Value B=3.
>
> calculation: 1 : 4 = 0,25    x 100% = 25%
>
> Pedro
>
>
>
> ----- Original Message -----
> From: "Dan Waters" <dwaters at usinternet.com>
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Sent: Monday, July 13, 2009 4:19 PM
> Subject: Re: [AccessD] calculation
>
>
>> 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
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>