Stumped--PLEASE HELP!?!

[omahatom]

This shouldn't be so difficult...I have a table with individual rows of data about individual phone calls including each start time and end time. I am trying to show a count by minute of simultaneous on-going phone calls.
I couldn't sequence queries to do this, so I had to go to excel and list each call in columns (with start and end times) and on the rows list each minute interval and copy a formula of embedded If statements (show 1 if call is ongoing in each minute interval) and then summed the totals of all calls.
I would rather keep this in Access but CANNOT figure out a good way to do this...any help would be GREATLY appreciated!
:banghead:

 

[stopher]

I've attached an example how to do it. Basically do a Cartesian product join with a a table containing all minutes in the day. A Cartesian product join is where you don't actually define and join between the two tables and because of this the query generates all possible combinations of the two tables which you can then filter. Counting is then a trivial exercise.

hth
Chris

 

[stopher]

Just some advice, you've posted pretty much the same question here and namliam took the time to respond to you. You should at least acknowledge his response even if it is just thanking him. But you should also put a note in the last thread to say you have started a new thread on the same topic. Otherwise people who are trying to help you will get frustrated if they find they are answering a thread that has already been answered elsewhere.

My example is pretty is pretty much exactly as namliam proposed so hopefully you will appreciate it as a workable solution.