C
Chi
Hi,
I have two fields: StartDate and EndDate. I would like my qry to pull out
all students who are at my class between StarDate and EndDate that I supply
as parameter.
Ex:
StartDate EndDate
Student 1 01/15/07 12/15/07
Student2 02/16/07 05/01/08
Student3 04/01/06 04/01/07
Student4 01/01/06 01/14/07
If I enter StartDate: 01/15/07 and EndDate: 12/15/07, I would like to have
student1 , student 2 and student 3 since either their StartDate or EndDate
fall between these dates ( between 01/15/07 and 12/15/07), but not student 4
since his StartDate and EndDate is not between 01/15/07 and 12/15/07.
Would you please help me on the criteria?
Thanks
Chi
I have two fields: StartDate and EndDate. I would like my qry to pull out
all students who are at my class between StarDate and EndDate that I supply
as parameter.
Ex:
StartDate EndDate
Student 1 01/15/07 12/15/07
Student2 02/16/07 05/01/08
Student3 04/01/06 04/01/07
Student4 01/01/06 01/14/07
If I enter StartDate: 01/15/07 and EndDate: 12/15/07, I would like to have
student1 , student 2 and student 3 since either their StartDate or EndDate
fall between these dates ( between 01/15/07 and 12/15/07), but not student 4
since his StartDate and EndDate is not between 01/15/07 and 12/15/07.
Would you please help me on the criteria?
Thanks
Chi