Access Select Query Count

[mike]

Hi,

I have a select query and I dragged in "Project Phase" as a field and
"Project Phase" has 4 major catergories for each project: Project in
Progress, Project in Review, Project Complete and *IT* (with various other
stages such as; design, development, migration and et cetera).

What I want to do is - I want to create 1 select query that shows the count
of projects in each phase.

 

[Jeff Boyce]

Mike

Open that query in design view.

Click the Totals button (the 'sigma' character) and select GroupBy for the
[ProjectPhase].

Add one more field that will be unique for each project (ProjectID?) and
select Count for it.

Run the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hi,

I have a select query and I dragged in "Project Phase" as a field and
"Project Phase" has 4 major catergories for each project: Project in
Progress, Project in Review, Project Complete and *IT* (with various other
stages such as; design, development, migration and et cetera).

What I want to do is - I want to create 1 select query that shows the count
of projects in each phase.

I have no trace of an idea what you mean by *IT* (with various...)

That said, create a new Query based on your table. Add the [Project Phase]
field to the query grid *twice*.

Change the query to a Totals query by clicking the Greek Sigma icon (looks
like a sideways M) on the toolbar.

Leave the default Group By on one of the instances of the field and change it
to Count on the other one.

 

[Dirk Goldgar]

Hi,

I have a select query and I dragged in "Project Phase" as a field and
"Project Phase" has 4 major catergories for each project: Project in
Progress, Project in Review, Project Complete and *IT* (with various other
stages such as; design, development, migration and et cetera).

What I want to do is - I want to create 1 select query that shows the
count
of projects in each phase.

Are there, then, only 4 possible values for [Project Phase]? If so, change
your query to a Totals query, set the Total: cell under the [Project Phase]
field (in design view) to "Group By", drag the [Project Phase] field to the
query grid again and set the Total: cell under it to "Count".