Query

[leighms]

Hi
I am trying to create query to record calls & reason codes between certain times, by the month;
Ideally the report would appear as below;
Calls received between 5.00 and 6.00pm
Reason-------aug------sep-----oct---etc
abc-----------1---------4-------3----
def------------4---------6------4----
ghi------------5---------3-------3----

Thanks

 

[Alansidman]

What does your data table look like. If it is normalized, then I think you will need to have a cross tab query.

Look here:

http://www.datapigtechnologies.com/flashfiles/crosstab.html

Alan

 

[leighms]

Hi

Table looks like;
Reason for call--------Date-----time------etc

Basically just want to extract data for certain times to count the calls received in that time period and what they were for, by month

Regards

 

[Alansidman]

Have you looked at the link I provided??

 

[leighms]

i have tried using a cross tab query and it has worked for me for other reports, but I can't seem to get a query that gives me totals within the time range needed, it just lists all the times

 

[Alansidman]

Suggest you post a copy of db with sample data so that we can look at it and discern your issues.

Alan

 

[leighms]

Hi

Thanks for your help, but I just tried something and it worked! I swear I was doing this yesterday and it wasn't but now it is doing what I want!

Thanks again for your help

Regards