Hi,
I have a linked table by ODBC that contains records with a type field, start date and end date.
What I would like to do is to have Another table which I create with a full year, one record is one day. And one field called number of active records.
Then I would like that table to look at the records from the ODBC source to see how many records that was Active on each day in the year table.
If start date less than date and end date greater than date then plus 1. So I would get a sum in the number of active records.
I want to use this as a overview in a diagram.
Or is there Another way of doing a similar thing?
Anders
Sweden