Greetings,
What would the best way be to link a Calendar with a StartDate and EndDate in multiple tables (I have 14 tables which have start and end dates in them, the tables all link on a common IDNumber) Now I need to be able to select May 2015 and show all field where MAy 2015 is between StartDate and EndDate. I've tried using IntervalMatch but for example 1 of the tables which has 35000 records returns 22000000 records which put strain on the computer's resources (6MB RAM) and that only 1 table.
Any ideas?