A
Atlas
Hy there everyone.
My database (access 2003 adp + sqlserver) holds the following tables:
A->(Garages) ID Garage, Description
B->(Cars) - ID Car, ID Garage, Description
C->(Users) - ID User, Name
D->(Rentals)- ID Rental, ID Car, ID User, Date, Money_Amount
Would like to chart (or Pivot chart) to show, month by month (across
multiple years), a Money_Amount line graph for each car.
This should be the layout:
- On vertical axis car list
[Garage1]
-[car1]
-[car2]
-[car3]
....
[Garage x]
- [carx]
-On horizontal axis
[Year1 month1][month2][month3].....[Yearx month x]
Apart from generating the right SQL statement (can someone help?), should I
use chart or pivot chart? and how? I've tried by my self but getting wrong
results with pivotcharts....
Thanks for helping
My database (access 2003 adp + sqlserver) holds the following tables:
A->(Garages) ID Garage, Description
B->(Cars) - ID Car, ID Garage, Description
C->(Users) - ID User, Name
D->(Rentals)- ID Rental, ID Car, ID User, Date, Money_Amount
Would like to chart (or Pivot chart) to show, month by month (across
multiple years), a Money_Amount line graph for each car.
This should be the layout:
- On vertical axis car list
[Garage1]
-[car1]
-[car2]
-[car3]
....
[Garage x]
- [carx]
-On horizontal axis
[Year1 month1][month2][month3].....[Yearx month x]
Apart from generating the right SQL statement (can someone help?), should I
use chart or pivot chart? and how? I've tried by my self but getting wrong
results with pivotcharts....
Thanks for helping