I have invoice amounts due by various dates on one table and projected amounts due by various dates on another table. I’d like to combine the two on another table to see projected income. I do not want a sum of the values as I will create a pivot table in blocks.
Table 1
Inv No Customer Amount Due Date
Table 2
Job No Customer Amount Due Date
Combined Table
Job No/Inv No Customer Amount Due Date
How would I go about this?
Thanks
Mike