Unique records where not unique!

[RogerTE via AccessMonster.com]

We have an Access 2003 Query that returns records in following format:

User group
Incident No
User sub group
Time spent
Incident severity
Incident Status

There might be several records with the same User group and incident number,
but with different sub groups, and each record will have a time spent.
Incident Severity and status will be the same for all records

What we want to do is return a summary that just contains
User group
Incident number
Total time spent

I suspect this is very easy, but just can't get my head round it today.

Roger

 

[Dale Fye]

How about:

SELECT [User Group], [Incident No], Sum([Time Spent]) as TotalTime
FROM yourTable
GROUP BY [User Group], [Incident No]

 

[RogerTE via AccessMonster.com]

Thanks,

I had tried to do it using the Query builder, without success.

Roger

How about:

SELECT [User Group], [Incident No], Sum([Time Spent]) as TotalTime
FROM yourTable
GROUP BY [User Group], [Incident No]

We have an Access 2003 Query that returns records in following format:

[quoted text clipped - 17 lines]

Roger