Invoice Total VB Function
Posted on 1997-12-20
I would like to create a function in VB. I never wrote or used functions before. Here is the situation:
I have two tables: Invoice table & Account Receivables Table. Here are the fields:
Invoice Table: Invoice#, Date,(all customer Info fields), Total Labor.
A/R Table: Invoice#, Date, (all customer Info fields), Late Charge, Amount Paid.
I would like to have a Function to calculate the Total Invoice Balance so I can put it in several forms.
Here is the calculation:
([Invoice table]![Total Labor])+([Account Receivables Table]![Late Charges])-([Account Receivables Table]![Amount Paid])
I have no idea how to do this. Any help will be appreciated.