I am working on a db for an ambulance service. In the db, I keep track of event/calls and call times. IE 'time of call' and the 'time of completion'. The ambulance service serves a community with 40 to 55 thousand people. It's not uncomon to have three ambulances on calls/events simataniously. Some calls are 'emergency calls' and some calls are 'transfers' and some calls are 'stand-bys'.
I would like to keep track of how many times '2nd out' calls occure and how many times '3rd out' calls occure and how many times '4th out' call occure.....etc. There have been as many as 5 ambulances out on calls simataneously. With the growing population of the community, it's conceivable that in the following years, there may be as many as 10 ambulances out or busy at once. This would be very valueable information, ie when to add more staff and more stations........
Is there a way that this could be queried? Could any one walk me through the logic of creating a query that would derive the information I need?......
Many thanks in advance......
Shawn
I would like to keep track of how many times '2nd out' calls occure and how many times '3rd out' calls occure and how many times '4th out' call occure.....etc. There have been as many as 5 ambulances out on calls simataneously. With the growing population of the community, it's conceivable that in the following years, there may be as many as 10 ambulances out or busy at once. This would be very valueable information, ie when to add more staff and more stations........
Is there a way that this could be queried? Could any one walk me through the logic of creating a query that would derive the information I need?......
Many thanks in advance......
Shawn
