I have a table with service ticket #, Enter Date, and Closed date.
What I am trying to query is the quantity of open tickets (tickets entered not closed) for each week.
So If a ticket was entered on last Monday but was closed any time during the week - it would not be counted.
If a ticket was entered on last Monday - is was not closed by Friday - it would count as 1 Ticket in Queue for that week.
I am not sure how to structure the query to return records per week with number of Open tickets in Queue.
Thanks for your help.