Please help me with a report

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
 
J

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

S.Ali

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
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top