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