Totals On GroupFooter From Field2 Base On Criteria Of Field3

Getting the total in a GroupFooter from a Field2 based on Criteria on Field3. For instance, I could total values from Field2 based on criteria “KEY” of Field3, however my problem is when I try to get the valued from Field2, which has the same value for all records based on criteria “NoKEY” of Field3.



I’m not sure if this is the best way to explain my problem, but I’ll try to give you a better scenario for you reply. I really appreciate if you help me out in anyway that lead me to the right procedure.


Here is my code for the ControlSource of my unbound for Field1



=Sum(IIf([Field3]="KEY",[Field2]))



How can I capture the value on [Field2] based on criteria [Field3]=”NoKEY”?





Thank so much in advance.