Code to add Yes and N/A's

[Brian62]

I am trying to add the Yeses and N/A's in a query from my table. I have tried to count, sum and Sum(Abs and I can not get them to add up correctly. All it is doing is adding the total count in the column. I also need to add the No's separately from the others. Thanks!

 

[John Big Booty]

Try using a totals query. In your first column group by your Field and then in your second column Count that same Field.

 

[Brian62]

I need to add the yeses and N/A's as one in the same column. This is going to a report and there are a lot of columns (around 80), that's why I am trying to combine the two plus they represent the same total since I count them as if they were both yeses.

 

[John Big Booty]

Why so many columns

 

[Vassago]

Sum(Iif([Field] in ("Yes","N/A"),1,0))

 

[Brian62]

That worked perfectly. Thanks!!!!

 

[Vassago]

Glad to help.