Row Level Statistics

[Topflite66]

I am working on an Access 2003 database that I need to do calculations accross several columns on a single row. I found this link in an earlier post:

http://support.microsoft.com/?kbid=209839

This helped with the Count, Average and Sum functions, however I need to also be able to count a specific value accross several columns. I'm not very familiar with VBA so was wondering if anyone knew a way to modify the RCount VBA code to count a specific value? Thanks in advance.

[Rabbit]

You can put in an If statement to check the value before doing the count or sum.

[Topflite66]

Each time I tried adding another If Statement I got unexpected results. So I added the And Operator to = the value I was trying to total and it worked. Thank you very much for your help.