Pedro Janssen
pedro at plex.nl
Mon Jul 13 14:37:02 CDT 2009
An extra criteria at B "3" wil give me the B3 percentages. Best Wishes Pedro ----- Original Message ----- From: "Drew Wutka" <DWUTKA at marlow.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, July 13, 2009 9:29 PM Subject: Re: [AccessD] calculation > No, it'll count everything. So you end up with a list of Grouped by > Patients and field 'B', with a Third Column giving the percentage. > > So with the test data of: (I added a few more rows) > > ID Patient B > 1 AA 1 > 2 AA 1 > 3 AA 2 > 4 AA 3 > 5 BB 1 > 6 AA 4 > 7 BB 2 > > That query returns: > > Patient B Percentage > AA 1 40% > AA 2 20% > AA 3 20% > AA 4 20% > BB 1 50% > BB 2 50% > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > Sent: Monday, July 13, 2009 12:54 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] calculation > > Will that count just the occurrences of test score = 3? > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka > Sent: Monday, July 13, 2009 9:57 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] calculation > > This should do what you want: > > SELECT T1.Patient, T1.B, (SELECT Count(*) FROM tblPatients WHERE > Patient=T1.Patient AND B=T1.B)/(SELECT Count(*) FROM tblPatients WHERE > Patient=T1.Patient)*100 & "%" AS Percentage FROM tblPatients AS T1 GROUP > BY > T1.Patient, T1.B; > > I made your table (with ID, Patient, B as the fields) and called it > tblPatient. > > Drew > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen > Sent: Monday, July 13, 2009 9: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 > The information contained in this transmission is intended only for the > person or entity > to which it is addressed and may contain II-VI Proprietary and/or II-VI > Business > Sensitive material. If you are not the intended recipient, please > contact > the sender > immediately and destroy the material in its entirety, whether electronic > or > hard copy. > You are notified that any review, retransmission, copying, disclosure, > dissemination, > or other use of, or taking of any action in reliance upon this > information > by persons > or entities other than the intended recipient is prohibited. > > > -- > 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 > The information contained in this transmission is intended only for the > person or entity > to which it is addressed and may contain II-VI Proprietary and/or II-VI > Business > Sensitive material. If you are not the intended recipient, please contact > the sender > immediately and destroy the material in its entirety, whether electronic > or hard copy. > You are notified that any review, retransmission, copying, disclosure, > dissemination, > or other use of, or taking of any action in reliance upon this information > by persons > or entities other than the intended recipient is prohibited. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >