Search results for query: *

Will do next time. I thought I explained it well enough, along with the sample coding.

SELECT [Last Month Incidents].[Assignment Group], Count(*) AS MonthlyCount, Sum(IIf ([Last Month Incidents].[Business duration] >432000,1,0)) AS Over5Days FROM [Last Month Incidents] GROUP BY [Last Month Incidents].[Assignment Group]; I actually heard back from a friend that figured it out...

Yea, that works. I guess I was just hoping to get that output, Total amount closed, and then other "WHERE" statements all in one query. I'd end up using 5 different queries for Totals, same day closures, 3 day closures, 5 day closures.

I can do this by creating new fields and altering data, but since others may need to fill in for me, I'd like to keep this as seamless as possible, so I'm willing to do more work (SQL coding) to minimize manual work.

The example in my coding is me trying to add a column that will give me the total amount tickets closed by that group that exceeded 5 days opened. The Over5Days is giving me the amount of tickets Over5Days for all groups, not each individual group.

Hey Skip, I'm actually refining the reporting we do by creating an Access Database that will calculate certain numbers that we regularly report on. I pull the information from out ticketing system which gives us Business Duration in seconds [neutral] 5 days is our SLA on these tickets. By...

Good Morning! I'm new to SQL coding and am trying to find a way to run a query and look to need some help Table: Last Month Incidents Used Columns:Assignment Group, Business duration Issue:I have a table populated by incident tickets along with a field for Business Duration that shows how long...