SUM using two feilds

K

KAnoe

I would like the report to give me a Sum in a text box but only if it meets
the criteria of two fields. I know how to do it for one. I have been using
the following for just one field.
=Abs(Sum(Left([ED_Code],1)="L"))

I would like to have it also check a second field [AFQT] that is Greater
that 49.

Thanks

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Sum Check Box 5
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Creating a Search using a combo box and then creating a report. 4
Sum a field with null value 8
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Counting with 2 Conditions 2
ASK Field Formatting 1

Top