Back here after some time...
I've been investigating Partition function with no luck.
My scenario is:
1) I have lookup tables with a key field and two dates: PlatiOd and PlatiDo (DateStart and DateEnd).
2) Data table (Denik) has a field DATUUP and 9 fields pointing to various lookup tables with PlatiOd and PlatiDo.
3) Each key-field in Denik has its own lookup table.
4) I need to evaluate Denik.DATUUP and a key-field against an appropriate lookup table to get correct information, ie. values of other fields from the lookup table.
Cis3Uc04 (lookup table for SU)
SU DPH PlatiOd PlatiDo
321 True 01.01.2008 31.12.2008 (CZ format for Dec 31 2008)
321 False 01.01.2009 31.12.2009
321 True 01.01.2010
SQL query should return something like this:
Denik.DATUUP Denik.SU Cis3Uc04.DPH
05.05.2008 321 True
09.09.2009 321 False
10.10.2008 321 True
It would be an easy task for a database with interval keys. But I can't make it work in "modern" Access.
Thank you very much for your time in advance.