hockey8837
Registered User.
- Local time
- Today, 13:51
- Joined
- Sep 16, 2009
- Messages
- 106
Hi,
I've got a DB in which records have a start date and an end date.
I'd like to be able to run a parameter query that will prompt which month I'd like to look at, and return all records which fall into that month.
I haven't been able to figure out the right way to set this up, as I only get the start month records appearing (i.e. I'll want June, and only records with a June start date show up, rather than records that also start in May and end in August, etc., showing up, too).
My ultimate goal is to be able to look at a month-by-month report and see all records which fall into each month (yes, this will give duplicates, but that is okay).
I'm using Access 2007 and Windows XP.
Thanks!
I've got a DB in which records have a start date and an end date.
I'd like to be able to run a parameter query that will prompt which month I'd like to look at, and return all records which fall into that month.
I haven't been able to figure out the right way to set this up, as I only get the start month records appearing (i.e. I'll want June, and only records with a June start date show up, rather than records that also start in May and end in August, etc., showing up, too).
My ultimate goal is to be able to look at a month-by-month report and see all records which fall into each month (yes, this will give duplicates, but that is okay).
I'm using Access 2007 and Windows XP.
Thanks!