Call Centre Database

[marko23]

Hello all,

Im really hoping someone can take a look at my database and help me!!

I have a query within my database that hold five different Departments, and each department has two difference phone numbers.

What im trying too do is add together the statistics of the two phone numbers that relate to the department!

And also be able too do a search by a cumulated date range, and by multiple departments!

Please, please, please, could someone look at my database and advice me

Many Thanks

Mark

 

[KenReay]

Hi

add together the statistics of the two phone numbers that relate to the department!

see aggregate query in help

be able too do a search by a cumulated date range,

see parameter query in help

by multiple departments!

see parameter query, list box and WHERE IN (SQL) syntax in help


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK