Chart or Pivot Chart? Advise needed

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
 
A

Atlas

Atlas said:
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

Anyone wishing to help?
 
P

Peter Hibbs

Atlas

You could probably do this using a Flex Grid control. Have a look at
my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples, although the VBA code required to update the table
would be fairly complex.

Good luck.

Peter Hibbs.


Atlas said:
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

Anyone wishing to help?
 
A

Atlas

Hi Peter,
I've downloaded the demo but it doesn't look like a a chart management
control, rather a data grid control.....


Peter Hibbs said:
Atlas

You could probably do this using a Flex Grid control. Have a look at
my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples, although the VBA code required to update the table
would be fairly complex.

Good luck.

Peter Hibbs.


Atlas said:
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

Anyone wishing to help?
 
P

Peter Hibbs

Atlas

Fair enough, I wasn't sure from your description whether you wanted a
horizontal progress line type display (which could be done with a Flex
Grid) or something more complex.

Peter.

Hi Peter,
I've downloaded the demo but it doesn't look like a a chart management
control, rather a data grid control.....


Peter Hibbs said:
Atlas

You could probably do this using a Flex Grid control. Have a look at
my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples, although the VBA code required to update the table
would be fairly complex.

Good luck.

Peter Hibbs.


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


Anyone wishing to help?
 
M

Michael Gramelspacher

atlaspeak@my- said:
Hi Peter,
I've downloaded the demo but it doesn't look like a a chart management
control, rather a data grid control.....


Peter Hibbs said:
Atlas

You could probably do this using a Flex Grid control. Have a look at
my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples, although the VBA code required to update the table
would be fairly complex.

Good luck.

Peter Hibbs.


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]

William E. Pearson has tutorials here under the Access section:
http://www.databasejournal.com/article.php/1459531

Helen Feddema has some examples here. Nunbers 86 & 87.
http://www.helenfeddema.com/access.htm
 
Top