Another Access Query

[mikeymay]

I have a table that contains the following fields
Buyer
Contact Date
Contact Channel
Contact Details

I want to return records via VBA code where the Contact Date is < 30 days ago and to only return the latest record (max Contact Date) for the Buyer.

I am struggling with the query string and have the following
SELECT Buyer, MAX(Contact Date) as MaxDate, ContactChannel, ContactDetails FROM BuyerContact WHERE ContactDate <= #26/02/2018#


TIA

 

[ranman256]

https://www.mrexcel.com/forum/microsoft-access/1049513-access-queries-via-excel-vba.html

but youd want to calculate the days too
dateDiff("d",[ContactDate ],date())

then in criteria <30