March 9, 200817 yr 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, 200817 yr by Guest
Create an account or sign in to comment