Hi, I have 2 tables:
SalesGOALSAppend, has LOCATION and SALES GOAL and DATES
EWCHoursBudget, has LOCATION and SALES GOAL and HOURS BUDGET
I would like SalesGOALSAppend to look up in what the EWCHoursBudget are when SALES hit a number.
So if sales at 9100 in SalesGOALSAppend hit $100,000 look...