If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help me with a report
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 |
#2
|
|||
|
|||
Please help me with a report
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 |
#3
|
|||
|
|||
Please help me with a report
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 . |
Thread Tools | |
Display Modes | |
|
|