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.