Grouping by customer number

[supraTT]

Hey guys i needsome help i have a table that lookslike this

CustomerNumber Trans Date Trans Amount
10 5/1/2002 10.00


I need to make a graph that will be based on Customer number, and Date, (meaning each line represents a customer number and the amount of thier transaction)

i wish i could explain better!

Also, there is a field in a seperate table that has a date and price, but it is a cost field, something i want to compare using the graph. so i would need to add it in as well

Any help would be appreciated

 

[synapsevampire]

Mock up a text example of what this report needs to look like.

As for the data in the other table to *compare* to, if it's to be on the same graph, you'll need some means to link the data (perhaps they both share customer number?).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[supraTT]

No they bot share the same date which is what we would like to have it linked with, i can acctually put it in the same table easy!


hmmm, as far as a text example, im not sure what ya mean, i could give you a "paint" example! hahaha

Basicly i need a line graph, that uses the customer numbers to define the points on the graph. but multiple customer number. based on date and price.

Havint the X axis based on date, and the y on a scale of 0-1.50 dollars