By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,469 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Row Level Statistics

P: 2
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.
Apr 22 '13 #1

✓ answered by Rabbit

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

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,327
You can put in an If statement to check the value before doing the count or sum.
Apr 22 '13 #2

P: 2
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.
Apr 23 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.