OMG :banghead::banghead::banghead::banghead::banghead::banghead:
This was SOOOOOOOOOOOOOOO easy after you mentioned that last bit and I googled it and realized that access 2010 basically does it all for you!
Its basically/is what VBAiNET said ages ago that I couldn't get to work properly with his example and my stupidness!!!
SELECT Table1.CustID, Table1.InterDate, Table1.Agent, Table1.Note
FROM Table1
WHERE (((Table1.CustID) In (SELECT [CustID] FROM [Table1] As Tmp GROUP BY [CustID] HAVING Count(*)>1 )) AND ((Table1.InterDate) Between Date() And Date()-7))
ORDER BY Table1.CustID;
attached the DB with it working in case anyone else is as retarded as I am
Thank you so much for all the help! Sorry it took so long for me to get across what I was trying to get out if the DB :banghead:
So happy now