Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisevans_cj
Contributor III
Contributor III

Multiple Tables with Start End - Calendar Link

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?

0 Replies