ANDREW_SAUNDERS
Registered User.
- Local time
- Today, 11:02
- Joined
- Mar 11, 2002
- Messages
- 12
I have a holiday database where [1stday] and [Lastday] are entered
I need to find all records that have a date within a certain week with a date range of Sunday to Saturday
I have a problem with my current idea in that if one or both of [1stday] or [Lastday] are out side the selection criteria then they are not selected ie a holiday of 14 days !!!
Any Sugestions?
I need to find all records that have a date within a certain week with a date range of Sunday to Saturday
I have a problem with my current idea in that if one or both of [1stday] or [Lastday] are out side the selection criteria then they are not selected ie a holiday of 14 days !!!
Any Sugestions?