If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.

I have a database which contains an events table, fields a
Event Title, End date, Start date, Start time, End time, Frequency (this is a combo for weekly, daily, monthly, one off)

What I want to do is have a query that will pull out events which occur between the start and end dates, It may be that the user will want a report which displays events taking place on a particular day or between a range of dates. The database is for staff organising evening classes and events.

I am presuming that this will be like a parameter query where the user will be prompted to enter a start and end date to get the result.

My problem is it has been ages since I used Access and I cannot get my head around how to make the query work, I have only used basic queries or simple parameter querys before.