Hi,
I have a table that gets updated on a weekly basis with the names of active users. I'm trying to make a query that tells me which users are missing from the current week compared to the entire table/all previous weeks. I only want the user to show up once, and it has to be the newest data for that user.
If I do a Select *, this is what the table would look like
Code:Name Effective_Date Position User1 09/18/10 A User2 09/18/10 A User3 09/18/10 A User4 09/18/10 A User5 09/18/10 A User6 09/18/10 A User1 09/25/10 B User2 09/25/10 B User3 09/25/10 B User4 09/25/10 B User5 09/25/10 B User6 09/25/10 B User1 10/02/10 C User2 10/02/10 C User4 10/02/10 C User5 10/02/10 C User6 10/02/10 C User1 10/09/10 D User2 10/09/10 D User4 10/09/10 D User6 10/09/10 D
Expected Query Results
How would I write a query that gives me this data? I've read about creating a query that compares the single table as if it were two tables, but I couldn't get that working.Code:Name Last_Date Last_Position User3 09/25/10 B User5 10/02/10 C