please help me count the number of days for each tech in a team

[kwill]

Tech Team Dispatch Date
OJON COLU 10/8/2001
OJON COLU 10/9/2001
OJON COLU 10/10/2001
OJON COLU 11/13/2001
OJON COLU 11/15/2001
OJON COLU 11/16/2001
OWIL COLU 10/8/2001
OWIL COLU 10/10/2001
OWIL COLU 10/15/2001

I've made a query to pull this data based on the team. How do I count the number of days of each tech (there will be hundreds)has worked. I do have a query that lists other info including the different techs.

Here's the summary info which lists the techs I want to query on:

Service Co REGION Team Tech Average Travel time
9993 NAMW COLU OWIL 35.3333333333333
9993 NAMW COLU OJON 88.9074074074074


Any ideas would help. I've tried several things but none of them work, obviously. Thanks!

 

[raskew]

Try a totals query where you group on Team and Tech and count Dispatch Dates. Here's an example:

SELECT tblTechs.Team, tblTechs.Tech, Count(tblTechs.DteDispatch) AS CountOfDteDispatch
FROM tblTechs
GROUP BY tblTechs.Team, tblTechs.Tech;

 

[kwill]

You Rock! I got it to work! I don't know SQL yet. How would I do that in query design? Thanks Raskew

 

[raskew]

Substitute 'Creak' for 'Rock' and you'd probably be closer to the truth.

To create the query in query-design:

Create a new query, specifying your equivalent of tblTechs.

Pull your equivalent of Team, Tech and DteDispatch into the query grid.

From the toolbar, click on the Greek E (sorry, can't duplicate the symbol) or
View | Totals.

A Totals row will be added to the grid, with each column initially each indicating Group By.

Change the DteDispatch Totals to Count and run the query.