From: S.Ali on
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
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
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
> .
>