Number of SQL in MS Access
I have a table called [Review Results] that looks something like this:
[Reviewed By]....[Review Date]....[Corrective Action]....[CAR]
John.............1/1/2011.........yes....................yes
John.............2/5/2011.........No.....................yes
John.............2/24/2011........yes....................yes
Bobby............1/1/2011.........No.....................No
Bobby............3/1/2011.........yes....................No
I am trying to display a number from a [Corrective Action] = yes
reviewer for a specified period, as well as a number [CAR] = yes
from a reviewer for a specified period. I tried using the following SQL, but it doesn't give the correct output:
select
[Reviewed By],
Count(IIF([Corrective Action] = yes, 1,0)) as [CAMBRs],
Count(IIF([CAR] = yes,1,0)) as [CARs]
from [Review Results]
where [Review Date] between #1/1/2011# and #3/1/2011#
group by
[Reviewed By]
Can anyone point me in the right direction using SQL?
+3
source to share
2 answers