I've got a form with three calculated fields - Total Pledges Raised, Total Pledges Received and Total Pledges Outstanding for each GolferID record.
Pledges Raised and Pledges Received are calculated through queries and displayed on the form using the DLookup function.
Total Pledges Outstanding is a calculated textbox using the formula [TotalRaised]-[TotalReceived].
My problem is that if the Total Received query contains no data, the Total Outstanding box is blank - I want it to act as if there is a $0 value in Received and to display the value contained in the Total Raised.
example:
Total Raised = $50
Total Received = $0
Total Outstanding = $50 (right now, Outstanding is blank)
All assistance much appreciated!
Pledges Raised and Pledges Received are calculated through queries and displayed on the form using the DLookup function.
Total Pledges Outstanding is a calculated textbox using the formula [TotalRaised]-[TotalReceived].
My problem is that if the Total Received query contains no data, the Total Outstanding box is blank - I want it to act as if there is a $0 value in Received and to display the value contained in the Total Raised.
example:
Total Raised = $50
Total Received = $0
Total Outstanding = $50 (right now, Outstanding is blank)
All assistance much appreciated!