Crosstab Query should work for this?

Hi

I have been asked to do something for one of the departments in my office -
I thought it would be easier than it's turning out.

They have a years worth of history for calls for each department in the call
center -split up into half hourly intervals:

The fields are

Date (dd/mm/yy)
time (10:30 or 11:00, or whatever)
Team (department)
Day (Monday / tuesday / whatever)
Calls abandoned
Calls 30 seconds
etc
....


They want to know, over that year, how many of each day of the week there
was per team.

So if Team A don't work bank holiday Mondays then there will have been no
calls coming in that day so no records, and less Mondays than there would be
for Team B which works 365 days a year.

I seem to be hitting a brick wall though because I set up a crosstab query
and it is saying there are 81 mondays a year?

Can anyone help please?

Thanks as always

--
Tails (The not so expert 'Expert' of their office)

Good afternoon

I'm not sure that a Crosstab Query is the appropriate solution.

I provided a solution a few years ago that sounded very similar to this one.

Could you provide the type of data you are working with ( i.e. text file ) and
what is your record layout.

Best regards

Maurice St-Cyr

Micro Systems Consultants, Inc.





Hi

I have been asked to do something for one of the departments in my office -
I thought it would be easier than it's turning out.

They have a years worth of history for calls for each department in the call
center -split up into half hourly intervals:

The fields are

Date (dd/mm/yy)
time (10:30 or 11:00, or whatever)
Team (department)
Day (Monday / tuesday / whatever)
Calls abandoned
Calls 30 seconds
etc
....


They want to know, over that year, how many of each day of the week there
was per team.

So if Team A don't work bank holiday Mondays then there will have been no
calls coming in that day so no records, and less Mondays than there would be
for Team B which works 365 days a year.

I seem to be hitting a brick wall though because I set up a crosstab query
and it is saying there are 81 mondays a year?

Can anyone help please?

Thanks as always

--
Tails (The not so expert 'Expert' of their office)