Thank you for responding to my question.
I apologize that my example was not very clear.
I have a list of 450 kids in the Little League from 4 years old to 14 years old. I need to figure there league age for all the kids. The league age cut off date is 4/30/2009.
If John dob is...
I volunteered (first mistake) to do a data base for my kids Little League. Everything is going well until I get to the League Age which is different from actual age. 04/30/2009 is the cut off date.
John dob is 04/30/1997 he's age 12 and his league age would be 12. If
johns dob is 05/01/1997...
I need to query to look at a whole week or two sometimes even a mounth at a time . But i can only get it to see one day. Like a schedule from 08/05/2008 to 08/25/2008, right know i can only see 08/05/2008