Portal Sum

[Fred in Thailand]

Data Base tracks contract payments.

Displays payment schedule in a portal.

I need to sum the total where The Date paid is empty as we do not track the payment amount to use in the calc.

Lets say there are 12 payments scheduled.

The first 3 have been marked as paid by entering the date in the date paid field.

I would now like to count the number of Empty Date paid fields and multiply that by the payment amount field to arrive at a balance due.

Hope I made even a little bit of sense.

What I can't figure out is how to count the number of records that have an empty date paid field.

Edited March 9, 2008 by Guest

[Fred in Thailand]

Never Mind... Figured it out MYSELF