I need a program that can cross-reference two databases by Customer First Name, Customer Last Name, Customer Address, Customer Zip, Co-Buyer First Name, Co-Buyer Last Name, Co-Buyer Address, and Co-Buyer Zip in database one with the same fields in database two. Then generate a report on the ones that match.
The report needs to contain the following:
• Customer Number
• Deal Number
• Deal Book Date
• Customer First Name
• Customer Last Name
• Customer Address
• Customer Zip
• Co-Buyer First Name
• Co-Buyer Last Name
• Co-Buyer Address
• Co-Buyer Zip
• Phone Number
• Email Address
• Vehicle Year
• Vehicle Make
• Vehicle Model
• Vehicle VIN
• Front Gross
• Back Gross
Then in a Summary of all Matches list the Total Sold(matches), Total Profit Generated(total Front Gross and Back Gross).
