Ignore names that have appeared in last seven days.

[Darren Bartrup]

I've been racking my brain over this and my SQL brain seems to have gone on holiday.

What I want to do is only select the users that have not appeared in the last seven days - so in the example below if the current date is 26/06/2012 then Darren wouldn't appear at all as he appeared on the 24th, but Alan would.
Could someone help me out in getting this started please? Thanks!

Access 2007
	B	C
24	ListDate	User
25	11/04/2012	Darren
26	25/04/2012	Darren
27	24/06/2012	Darren
28	26/06/2012	Darren
29	02/06/2012	Alan
30	01/06/2012	Alan
31	26/06/2012	Alan
32	11/06/2012	Alan
Contact_List_CL

 

[Joe4]

Create a query (subquery) that returns a list of all the users within the past 7 days.
Then create a new Unmatched query using this subquery and your original table (joining on the User name field).

 

[Darren Bartrup]

Thanks for your reply Joe. Makes sense when someone else says it.