[AccessD] calculation

Pedro Janssen pedro at plex.nl
Mon Jul 13 13:57:53 CDT 2009


Hello Stuart,

even with this and a lot of other quotes and other things that i tried, i 
receive syntaxerrors.
Don't bother, Drew's solution is working.

Thanks

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 8:34 PM
Subject: Re: [AccessD] calculation


>I missed a closing quote after the 3.
>
> Select Patient,Dcount("*","[Test]","Patient = '" & Patient & "' AND B = 
> 3") /
> Dcount("*","[Test]","Patient = '" & Patient & "') * 100 Group  by Patient;
>
>
>
> On 13 Jul 2009 at 19:13, Pedro Janssen wrote:
>
>> 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
>> >
>>
>> -- 
>> 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
> 




More information about the AccessD mailing list