Hi! I have a form that allows the user to enter a date range. The program then scans through a table looking for treatments that are done at any time during the entered period ie between two dates.
So treatment 1 is usually done between 03/02 and 04/28.
treatment 2 between 05/01 and 05/15. etc etc
The only way I can think to do this is to loop from the entered start & end date a day at a time and check that that date falls between each treatment.
This works fine but is a little slow, keep thinking there must be a way of doing this using an equation/syntax.
Thinking about this makes my head hurt! LOL, Any ideas?
Hope this makes sense!
TIA
Rob