Search results

I have multiple tables. Both have a similar unit number. What I want to do is match those and then have criteria like for one have it check to make sure Renew is Yes and for the other one say when Lease Exp_Date is end of this month. Here is the code I have and it does not work...