Please help me with a report

  • Thread starter Thread starter S.Ali
  • Start date Start date
S

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
 
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
 
Its good.
Thanks John


John Spencer said:
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 said:
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
Click to expand...
.
Click to expand...
 
Back
Top