Recent content by Surjeet729

Thank you so much!! I'll test this out!

The table tracks monthly statuses for each ticket. It pulls data from monthly reports.

A. Current Data: (also has an ID column, however the same ticket may have multiple IDs. There is a creation_date column that say when the ticket was initially made and a last_modified date as well.) I'm not 100% confident that the last_modified date corresponds to status, although there's a good...

Agreed, and that would be a good first step!

Yes, a rolling count of days for each ticket status. By average, they're looing for the average time all tickets are in a given status. So average for "Pending" might be 14, average for "Open" 45 days etc.

I need help with an Access query. The request is for a rolling average in days that a ticket is in a given status. IDs are set to auto-increment, so the same ticket will have multiple IDs for different months. I've been working with Ticket_Name for this reason. The set-up is below: Date |...