flying linus
Registered User.
- Local time
- Today, 02:28
- Joined
- Oct 1, 2004
- Messages
- 33
I have a table that shows the the status of the record as "Not Started", "In Work" or "Complete"
I want to count the number of records that fall into each category. I am currently doing the following SQL:
SELECT tblTest_Case_Status.Test_Case_Status, Count(*) AS NumberofRecords
FROM tblAV_Fail_Cases, tblTest_Case_Status
GROUP BY tblTest_Case_Status.Test_Case_Status;
However, it displays the status, but the count for each status is the total record count, not a breakdown of each. FOr instance, if I have 33 records, the count for each status is 33, not as expected:
Not Started 20
In Work 13
Complete 0
I am new to this so any help is appreciated.
I want to count the number of records that fall into each category. I am currently doing the following SQL:
SELECT tblTest_Case_Status.Test_Case_Status, Count(*) AS NumberofRecords
FROM tblAV_Fail_Cases, tblTest_Case_Status
GROUP BY tblTest_Case_Status.Test_Case_Status;
However, it displays the status, but the count for each status is the total record count, not a breakdown of each. FOr instance, if I have 33 records, the count for each status is 33, not as expected:
Not Started 20
In Work 13
Complete 0
I am new to this so any help is appreciated.