I have tried this approach and it keeps giving an error saying i have to create the joins in SQL.
So i've had a play around and constructed an IIF statement that in my mind should give me my desired results but it is still failing to show the differing data from the DataToday table instead just showing blank cells, can't see where i'm going wrong with this.
Here is the statement: I read it as If the results in DataToday are not equal to the results in DataYesterday then output the result in the DataToday table
Code:
Original: IIf([DataToday].[Full Name]<>[DataYesterday].[Full Name],[DataToday].[Full Name])