From: S.Ali on 27 Mar 2010 10:42 Can anyone help me with this report? I have a main table with fields of Serial No, Project No, Role1, Role2, Role3, Role4. Role1 is Supervisor, Role2 is Manager, Role3 is Developer, Role4 is QA. And the [Role] filed is boolean. I have to find 1) the list of [Project(s) No] with >= to 2 roles. 2) Count of [Project No] with >= 2 roles. Please help me. I will appreciate Salman Ali
From: John Spencer on 27 Mar 2010 10:54 SELECT [Project no] FROM SomeTable WHERE Abs([Role1] + [Role2] + [Role3] + [Role4]) >=2 In query design view == add your table == add the field(s) you want to see == add a calculated field (in a blank field box enter) Abs([Role1] + [Role2] + [Role3] + [Role4]) == Enter >=2 in the criteria for this calculated field John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County S.Ali wrote: > Can anyone help me with this report? > I have a main table with fields of Serial No, Project No, Role1, Role2, > Role3, Role4. > > Role1 is Supervisor, Role2 is Manager, Role3 is Developer, Role4 is QA. And > the [Role] filed is boolean. > > I have to find 1) the list of [Project(s) No] with >= to 2 roles. 2) Count > of [Project No] with >= 2 roles. > > > Please help me. I will appreciate > > Salman Ali
From: S.Ali on 27 Mar 2010 13:29 Its good. Thanks John "John Spencer" wrote: > SELECT [Project no] > FROM SomeTable > WHERE Abs([Role1] + [Role2] + [Role3] + [Role4]) >=2 > > In query design view > == add your table > == add the field(s) you want to see > == add a calculated field (in a blank field box enter) > Abs([Role1] + [Role2] + [Role3] + [Role4]) > == Enter >=2 in the criteria for this calculated field > > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > S.Ali wrote: > > Can anyone help me with this report? > > I have a main table with fields of Serial No, Project No, Role1, Role2, > > Role3, Role4. > > > > Role1 is Supervisor, Role2 is Manager, Role3 is Developer, Role4 is QA. And > > the [Role] filed is boolean. > > > > I have to find 1) the list of [Project(s) No] with >= to 2 roles. 2) Count > > of [Project No] with >= 2 roles. > > > > > > Please help me. I will appreciate > > > > Salman Ali > . >
|
Pages: 1 Prev: Prevent Duplicates Next: Subform Causes Main Form to show same record Multiple times |