Query that returns LAST date as of 30 days ago

[joey]

The last date in the query works fine but when I add the criteria Date()-30 it will only return one date (the most recent).

The project is to group stores that have not been serviced within the last 30 days and only to return the last service date.


Thanks Joey

[June7]

Post the SQL statement of the query.

[joey]

Here is the SQL statement that returns the most recent service date for each store. What I need for the report is "IF there is no service date within the last Then return the last service date".
Thank you.

SELECT [Store Service LOG - Master Query].[Store Service LOG].Cust_Lookup.Value, [Store Service LOG - Master Query].[Store Service LOG].[Field Rep Name], Max([Store Service LOG - Master Query].[Store Service LOG].[Service Date]) AS [MaxOfStore Service LOG_Service Date]
FROM [Store Service LOG - Master Query]
GROUP BY [Store Service LOG - Master Query].[Store Service LOG].Cust_Lookup.Value, [Store Service LOG - Master Query].[Store Service LOG].[Field Rep Name]
ORDER BY [Store Service LOG - Master Query].[Store Service LOG].[Field Rep Name];

[June7]

"IF there is no service date within the last [30 days] Then return the last service date" is essentially just returning the most recent service date regardless of when it took place.