I am trying create a query that counts all records which have the field Hypotension=1 (which is Yes), but I only want to count the same customer once.
My table has 3 fields: RecID (primary key), MRN, and Hypotension
RecID Cus# Hypotension
1 6 1
2 6 1
3 7 1
then my query should count the total of 2 for "hypotension =1", not 3 because I only want to count records with the same Cus# only once. I've tried to use "DISTINCT", but it doesn't work b/c I want to count many fields in the same querry (more than 20), not just one field "Hypotension". Below is my Select code, but it counts all records (which is 3). I need to add criteria such as where to eliminate the ones with the same Cus#, however, I have no clue. Can somebody please help?
SELECT Count(IIf([Hypotension]=1,"Yes")) AS Hypotension_Y FROM tblReview;