Hi all,
I am trying to create some sort of a planning or timeschedule. It should display the days on the top and the locations on the left. So if a location is planned on a certain date, it should be highlighted or marked in the planning. I tried a couple of things already, but nothing really works. What I did so far, was a crosstab query, I managed to get the top row and locations displayed, but to have to right result at the right place I did not succeed.
Maybe I should try something else, so I am open to suggestions.
Here a view how it should like like
01-01 02-01 03-01 04-01 05-01 06-01 07-01 A X X X X X B X X C X X X D X X X X