Hi everyone.

I have designed a database that keeps a record of users 's details as they enter and leave the library.Examples of this fields are:

VisitorID,Name,TimeIn,TimeOut,DateOfVisit,NatureOf Visit

All the above are recorded in a table called visitDetails.
I have two tables and the other one is called Visitor which keeps a record of all visitor's personal details.

I would like to create queries that would print out records weekly,monthly,quarterly and yearly.

Thanks everyone for help.

Use the DatePart function to add columns to your queries that to show the various times. You can then set the criteria for the specific period you want.

You can also use crosstab queries or grouping to report on specific types of periods.