I'm not sure what to title this one, but I'm looking for a solution to calculate dates depending on certain criteria.
First the background. I'm creating a birthday list for students. Each student attends class once a week on a specific weekday (Monday to Friday). I need to figure out a way to calculate a date 3 classes before their birthday because we take pictures of them for their birthday. Simple, right? Just use a DateDiff calculation I thought.
But ... here's the snag. We have certain days set aside for holidays and when a class falls on a holiday, they basically lose a week if I did that calculation. Which means that there are only 2 weeks of classes prior to their birthday.
I'm not a programmer, so I've been using queries (and nesting queries) to figure this problem out. I've managed to figure out a partial solution, but because I'm creating a Cartesian type setup I'm getting some students listed seven times or more depending on the criteria.
Is there a way to filter out names in queries that come out more than once?
The basic fields I'm using is Name, Date of Birth, Holidays (in a separate and unrelated table). There are a few other fields, but they are not really important for this. All the other fields, etc are calculated.
Any help is greatly appreciated! By the way, I'm NOT a programmer, so if you think this can only done with programming, please keep in mind that I may have no idea what you're talking about ... but I have created a few simple private sub routines.
PS: On an unrelated note, how does one mark a thread as solved? I can't seem to find the button.
First the background. I'm creating a birthday list for students. Each student attends class once a week on a specific weekday (Monday to Friday). I need to figure out a way to calculate a date 3 classes before their birthday because we take pictures of them for their birthday. Simple, right? Just use a DateDiff calculation I thought.
But ... here's the snag. We have certain days set aside for holidays and when a class falls on a holiday, they basically lose a week if I did that calculation. Which means that there are only 2 weeks of classes prior to their birthday.
I'm not a programmer, so I've been using queries (and nesting queries) to figure this problem out. I've managed to figure out a partial solution, but because I'm creating a Cartesian type setup I'm getting some students listed seven times or more depending on the criteria.
Is there a way to filter out names in queries that come out more than once?
The basic fields I'm using is Name, Date of Birth, Holidays (in a separate and unrelated table). There are a few other fields, but they are not really important for this. All the other fields, etc are calculated.
Any help is greatly appreciated! By the way, I'm NOT a programmer, so if you think this can only done with programming, please keep in mind that I may have no idea what you're talking about ... but I have created a few simple private sub routines.
PS: On an unrelated note, how does one mark a thread as solved? I can't seem to find the button.