using expression builder in Access 2003

[KerryA]

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

[NeoPa]

In a header section (Page; Report or Group) you would add a control with the formula :

=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!