Please help me with a report

[S.Ali]

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

 

[John Spencer]

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]

Its good.
Thanks John

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

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

.