Query with counts for Chart in report

[PeterDuthie]

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

 

[slankc]

Looking at the date of the post, you probably know this already, but to count the total number of records, you just add a column with count(*)