I'm trying to run a query, based on an existing query.
I can't get the following to show which dates are due within a year =Now()-30
The SQL view currently is:
SELECT qryEventDates.*, qryEventDates.EventDate
The query is named 1-DueIn30 in the attached Example database.