Help

Combine Values and Dates from 2 tables

Topic Labels: Extensions
1392 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Brits
4 - Data Explorer
4 - Data Explorer

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

0 Replies 0