Heenan, Lambert
Lambert.Heenan at aiuholdings.com
Mon Jul 13 13:00:33 CDT 2009
Well that hardly surprises me! :-) Off the top of my head rarely makes it! Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen Sent: Monday, July 13, 2009 12:46 PM To: Access Developers discussion and problem solving Subject: Re: [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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com