Thread: [Solved| Write Query

I am trying to write a query for the attached database that will allow me to count the number of people who left after the event ended. In my data table I have the time the people left and the date of the event. In my eventtimes tables I have the time the event ended.

I need a query that will calculate how many, who attended the event stayed past until or past the end time.

Thanks,

I don't see an eventtimes table in this db nor do I see when the participants left. Why don't you dummy up this database to look the way you want the tables to look and then we can offer up a viable solution.

Alan

Show us a sample database. It is difficult to visualize what you are saying. It is easier to see what you are attempting to do. It will answer questions, how are the tables related (joined), formatted, what other fields have to be taken into consideration, etc. Take the time to dummy up the database so that it mirrors your production database but does not compromise your sensitive data. This is important if you expect to get some help here as many of us failed our mind reading exam. Othewise, we are only guessing at what you have and what you want.

See attached. Created an aggregate select query.

B50;
I looked at the attachment the first time you posted and it appeared to have no data that you were talking about. It was the same file that I had created earlier in your other thread. If you subsequently changed the file, there would be no way for me to know that unless you told me. Therefore, my request that you provide the data requested. I apologize for any confusion, but I am only trying to help you.

Alan

Here you go. Amended Query1 to address the request.