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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find a date between two date fields
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. Grateful for any help which can be given. Thanks Shirley |
Thread Tools | |
Display Modes | |
|
|