PeterDuthie
Programmer
Hello Everyone. I need to get back two values from a query - 1. the total number of rows in a table and 2. the number of "incidents" which have been "signed off" (i.e.) dealt with successfully within 48 hrs. The two values are intended for a pie chart. Here's what I've got:
SELECT Count([T-incidents].[Signed off]) AS [Closed within 48 hrs]
FROM [T-incidents]
WHERE ([T-incidents].[Date of incident] + 2) >= [T-incidents].[Signed off];
How can I get the query to return the total number of incidents.
Thanks again to everyone who reads this.
(I'm cross posting this to the "General discussion" forum - If I'm not supposed to do this please let me know)
Cheers,
Peter
SELECT Count([T-incidents].[Signed off]) AS [Closed within 48 hrs]
FROM [T-incidents]
WHERE ([T-incidents].[Date of incident] + 2) >= [T-incidents].[Signed off];
How can I get the query to return the total number of incidents.
Thanks again to everyone who reads this.
(I'm cross posting this to the "General discussion" forum - If I'm not supposed to do this please let me know)
Cheers,
Peter