Greetings.
We have a database which is used to log sick and annual leave. This is basically stored in tables using 'from' and 'to' dates. The main user now wishes to query the data by typing in from/to dates, to generate a sick report.
The problem I am having, is querying the data in a way that will give reliable results. If a person is sick for 2 months, and we run a query on sickness for 3 weeks during the period they are sick, the query would obviously not return this member of staff because their to/from dates were not within the query period.
I'm not fantastic with code, but I can get by. I'm having a real headache working this out, so if anyone has an idea of the best way to go about this, I'd be grateful. I'm not asking anyone to show me code, just a pointer on an efficient route to take.
Russell.
Carlsberg don't run I.T departments, but if they did they'd probably be more fun.
We have a database which is used to log sick and annual leave. This is basically stored in tables using 'from' and 'to' dates. The main user now wishes to query the data by typing in from/to dates, to generate a sick report.
The problem I am having, is querying the data in a way that will give reliable results. If a person is sick for 2 months, and we run a query on sickness for 3 weeks during the period they are sick, the query would obviously not return this member of staff because their to/from dates were not within the query period.
I'm not fantastic with code, but I can get by. I'm having a real headache working this out, so if anyone has an idea of the best way to go about this, I'd be grateful. I'm not asking anyone to show me code, just a pointer on an efficient route to take.
Russell.
Carlsberg don't run I.T departments, but if they did they'd probably be more fun.