andy_dyer
Registered User.
- Local time
- Today, 22:38
- Joined
- Jul 2, 2003
- Messages
- 806
Hi,
My query is using the following code:
SELECT Count(qryRatio.txtID) AS CountOftxtID
FROM tblInput, qryRatio
WHERE (((qryRatio.PosRatio)=1) AND ((tblInput.[12 weeks completed])=True) AND ((tblInput.[Non completer])="N/A") AND ((tblInput.[Non starter])="N/A"));
If I change the Count to Group By it tells me that the record count is 81 at the bottom.
As soon as i try and get this into the query instead by using the count function it gives me 23085!!
It works fine on other queries where I am counting the txtID, but with this it seems set on adding them all up...
Why????
My query is using the following code:
SELECT Count(qryRatio.txtID) AS CountOftxtID
FROM tblInput, qryRatio
WHERE (((qryRatio.PosRatio)=1) AND ((tblInput.[12 weeks completed])=True) AND ((tblInput.[Non completer])="N/A") AND ((tblInput.[Non starter])="N/A"));
If I change the Count to Group By it tells me that the record count is 81 at the bottom.
As soon as i try and get this into the query instead by using the count function it gives me 23085!!
It works fine on other queries where I am counting the txtID, but with this it seems set on adding them all up...
Why????
