Search results

Thanks Guus2005, I just decided to create 2 queries that have my data that I need and then call those queries up in my control source and that worked perfectly. I was killing myself with DCount so decided to try another avenue in creating queries and using SQL code to get the data I need to copy...

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...