Getting a count of a certain type of entry

[aaslezak]

I am trying to create a query where I would like to summarized it by the project number and then count the number of times a certain title appears on the table. When I do it this way it gives me no results?

[ranman256]

1. dont count TITLE , instead count ID.
2. uncheck TITLE

but you will need developer and estimate label
so make it 2 queries. 1 only for developer, 1 for estimate.

Batch: "Estimate"

[ranman256]

SELECT "Estimate" AS Batch, Count(ID) AS CountOfID
FROM Personell
WHERE (((Title) Like "Estimate*"))

[aaslezak]

I need to have the total by project number because I need to find out which projects have both estimate and developer in the title because I need to remove the estimate from that record when I get a developer assigned on the report.

[aaslezak]

I finally figured out how to get into the SQL view because I know that and I was able to write the query and then I converted it back to design view so the SQL looks like this:
SELECT Personnel.[Project ID], Count(Personnel.Title) AS CountOfTitle INTO [AMA IT Count Developer Estimate]
FROM Personnel
WHERE (((Personnel.Title) Like "Estimate*" Or (Personnel.Title) Like "Developer"))
GROUP BY Personnel.[Project ID];
and the design view looks like this where I had to choose the title two times.

To get to the SQL view right click the query tab and go to SQL view and start writing SQL and do the same to get back to design view.