Hello...
Got two tables where "vakter" is the main table, and "skift" is a table that stores som extra data that belongs to "vakter", the reason is that "skift" may contain several rows belonging to "vakter". "skift" contains two datetime fields; "from" and "to".
What I want to do is this...
I want to count the number of entries in "vakter" where "skift" may contain several entries for each entry in "vakter". I want to filter out the entries in "vakter" where the last entry in "skift" belonging to "vakter", and today is before the field "to" in "skift".
(Complicated?)
