AnsweredAssumed Answered

Filtering unpaid invoices

Question asked by MichaelLane on Sep 4, 2012
Latest reply on Sep 4, 2012 by MichaelLane


Filtering unpaid invoices



My database has 2 tables - [Main] and [Jobs] linked by the field [Client_ID].

In the [Jobs] table there are fields [Gross_Total] and [Date_Paid]. What I would like to do is have a field [Balance] in the [Main] table which calculates all the Gross_Totals for a specific client's jobs where the field [Date_Paid] is empty.

As always, any assistance would be much appreciated.