Query of date

[John M]

I have a mdb that is membership based and I need to have a
query that sends a report to let me know when a membership
is due. I have a field with a due date in the table how can
I set so that the list of due memberships is displayed for
all dues for the following month in advance

Thanks for the help

 

[John Vinson]

I have a mdb that is membership based and I need to have a
query that sends a report to let me know when a membership
is due. I have a field with a due date in the table how can
I set so that the list of due memberships is displayed for
all dues for the following month in advance

Use a criterion on this duedate field of

BETWEEN Date() AND DateAdd("m", 1, Date())

or if you want to also see overdue members, just

<= DateAdd("m", 1, Date())