If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query doesn't work on Win98 workstation | Bill | Running & Setting Up Queries | 1 | July 13th, 2004 08:53 PM |
How to work with "#error" result in a query | David Jensen | Running & Setting Up Queries | 2 | July 13th, 2004 03:03 AM |
Query won't work with THIS table | Alain | Running & Setting Up Queries | 2 | June 14th, 2004 03:56 PM |
Reference Main Report Crosstab Query from Subreport | blinton25 | Setting Up & Running Reports | 0 | June 7th, 2004 11:42 PM |
Crosstab Report and query | Newbie | Setting Up & Running Reports | 4 | May 26th, 2004 05:11 PM |