Recent content by grant22

I'm attaching a screenshot. So basically, a report is run each day, in which some fields may change day to day. So when a record has a field that changes, I want to be able to add it into the master table. In the screenshot, you can see that there are two different dates for unique value...

I'm trying to run a query which may have duplicate records, but different dates. I want to be able to compare new tables with the master table so it only looks at the most recent date to see if any changes took place. This is what I have so far, but still doesn't return what I would like...

Thank you!

SELECT* FROM test2 INNER JOIN test1 ON test2.Unique = test1.Unique WHERE test2.Day = (Select Max(test1.Day)) AND test2.Ex8<>test1.Ex8; - Getting a Syntax Error in my WHERE statement, can anyone point me in the right direction. Relatively new to SQL coding.