Special report on leaves database

[andressp]

Hello from Greece!

I found your forum by searching in the internet to find solutions for an access database that I am developing.


Here is one of my problems:
I have a table which records the leaves of the personnel

Name _______ From __________To

Abbot B ____1/1/2016 ______5/1/2016
Graham P ___3/1/2016______ 4/1/2016
Knight A ___2/1/2016 _______6/1/2016

I would like to have a report like this:

__________Abbot B _______Graham P _________Knight A

1/1/2016 ____x
2/1/2016 ____x ________________________________x
3/1/2016 ____x_______________x________________ x
4/1/2016 ____x_______________x________________ x
5/1/2016 ____x________________________________ x
6/1/2016 _____________________________________x


Could you tell me if this is possible?
I suspect that it has to do with the crosstab queries

Thanks for your time
Andreas

 

[stopher]

You need a table with a list of dates. Then you can do a "cartesian" product of the two tables and limit on the date ranges. Then make it a pivot.

I attach an example.

 

[andressp]

Thank you very much for your time !