SELECT COUNT data type mismatch problem

[carlisle]

Hi,

I'm trying to create a count on a tick box of products that have been reviewed, however, the SQL statment I am using (as I have for a couple of other counts will not work fo this dues to 'Data type mismatch' which I can only presume is due to the fact that is is a tick box....

SELECT COUNT (TechnicalServicestbl.RequestID) AS TotalAwaitingReview
FROM TechnicalServicestbl
WHERE (TechnicalServicestbl.[Current Status] = "Completed") AND ((TechnicalServicestbl.[Review]) = "No" )

I have used the same template for a different count of completed jobs of the day, which works fine so far as I can tell.

SELECT COUNT (TechnicalServicestbl.RequestID) AS CompletedJobsToday
FROM TechnicalServicestbl
WHERE (TechnicalServicestbl.[Current Status] = "Completed") AND (TechnicalServicestbl.[Date Complete]=Format(Now(), "mm/dd/yyyy"));

 

[grnzbra]

What is the data type of TechnicalServicestbl.[Review]?