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?

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