[AccessD] calculation

Hello Stuart,

i called my Table Test, but i get syntaxerrors (operator is missing).

Which is missing?

Select Patient,Dcount("*","[Test]","Patient = '" & Patient & "' AND B = 3) /
Dcount("*","[Test]","Patient = '" & Patient & "') * 100 Group  by Patient;


Pedro


----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, July 13, 2009 6:34 PM
Subject: Re: [AccessD] calculation


> Select Patient,Dcount("*","myTable","Patient = '" & Patient & "' AND B = 
> 3) /
> Dcount("*","myTable",Patient = '" & Patient & "'") * 100 Group  by Patient
>
>
>
> On 13 Jul 2009 at 15:55, pedro at plex.nl wrote:
>
>> 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
>