Date/time period criteria confusion

[dmc12]

Hi there

I have created a database in Access XP (2002). In a nutshell, the database records numbers of people attending a seminar; which can take place any number of times per week, and so hence can take place any number of times per month.

I have set up the query so that it can run immediately after a seminar to show the attendants who attended the seminar on that current date "Date()" in the criteria box. However, how would I go about setting it up so that it shows who attended every seminar in the current week or month?

 

[GAB]

In the column that contains your date in the criteria row in your query you could do something like this:
Between [DATE] And [WHAT DATE-365] this will prompt you for a start and ending date.
Hope this helps

Gary