Total with qualifications

G

Guest

I have a form that has a field named [subtotal].

On the same form, I have an Option Group named [status] that approves "1",
dissapproves "2" or is under review "3" for that record.

On the same form, I have a field named [total] that I would like to show the
sum of all my subtotals minus the dissapproved ones.

Thank You.
 

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

Top