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

using expression builder in Access 2003

P: 1
Hi, I am trying to create a report on a table I have set up called ‘Outcomes’. I need to be able to do a count of all fields that have said ‘1’ ‘2’ or ‘3’ within a field name called ‘All outcomes’. I have tried using the expression builder but nothing seems to be working for me. Any ideas? Thanks in advance
May 10 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
In a header section (Page; Report or Group) you would add a control with the formula :
Expand|Select|Wrap|Line Numbers
  1. =Count(IIf([All Outcomes] In('1','2','3'),'*',Null))
[All Outcomes] would need to exist as a control in the Detail section of your report, and the underlying field would need to be of type String.

Welcome to Bytes!
May 10 '10 #2

Post your reply

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