Query of date

  • Thread starter Thread starter John M
  • Start date Start date
J

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
 
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
Click to expand...

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())
 
Back
Top