Totalling the data from a query

[KalelGmoon]

Greetings,
I am working with a database where I query a table and get a set of data. it is a phone log database and I am trying to find the total number of calls that a certain ext. makes during a certain time. I have it now where it will give me a complete list of the calls made for the dates and the times, but it gives one for each call, I am just looking for a total for each ext not the detailed that it is giving me. any help would be much appreciated thank you

 

[Bee]

Greetings,
I am working with a database where I query a table and get a set of data. it is a phone log database and I am trying to find the total number of calls that a certain ext. makes during a certain time. I have it now where it will give me a complete list of the calls made for the dates and the times, but it gives one for each call, I am just looking for a total for each ext not the detailed that it is giving me. any help would be much appreciated thank you

use the sum function.

 

[KalelGmoon]

I tried the sum and I got an error message stating that it was too complex. so I suppose I will have to do it all by hand. I suppose it is a good thing it is only 20 or so lines instead of 100 or more.

 

[boblarson]

How is the call length defined in the query you are saying that it gave you the error message when you used SUM? Perhaps it isn't in the format that it needs to be in order to calculate the SUM. You don't need to give up, as you SHOULD be able to do what you want. It's just a matter of figuring out what you currently have and if that isn't correct, changing it so it is useable.

 

[gemma-the-husky]

total number of calls is COUNT, not SUM in a totals query. If you have a query, querying a single table, you can't possibly get a too complex query, so you have done something wrong in the design stage.

 

[KalelGmoon]

Victory!!!!!!

I got some help from a guy here in the office and we figured it out. we added a query that queried a query for the information then totalled it. so not that pretty but quick and dirty got the job done. thanks everyone for the help and the suggestions