Hey guys,
looks like there has been too much time since my studying days, for you this should be pretty easy:
I do have a pretty large rental database of the following format:
(basically table of rental contracts with period and number of equipments used)
equipA equipB fromdate toDate order1 1 2 order2 6 3 order3 4 2
What I need is this day-by-day aggregation of the equipement in use:
(how many equipments of type A,B,... are in use on each single day)
1.1. 2.1. 3.1. equipA 2 3 3 equipB 1 5 3
Thanks for any help in Access or SQL.
Cheers Thorsten