Problem with structure to build query for graph

[gerard1979]

I'm using Access2002. I'm making a lot of reports and graphs, some of them drive me crazy as the follow is doing. Maybe someone can help.
I need a graph with time (in points of entering) on the x-as and profits on the y-as. The legenda includes a few persons. They all need an own profit-line.
I make a table bases on the UsersID and his profit on that moment. The table is looking like:
UserID Profit
1 10.000
1 15.000
2 11.000
2 13.000
2 16.000
and so on.
Now I need for each user a line in the graph. I don't know if it's possible. The problem is: I can't make a table for each user because I don't know the exactly number of users.

Anyone suggestions how the query the data to get the right output/

thnx
gerard

 

[jksmi]

Hi,
I would have thought a cross tab should solve most graphing issues but you don't mention where time is on the table? i.e. are you tracking users profit over time or if your pulling out a snapshot of user profit to date is your base query correct? surely each user can only create 1 profit figure each moment?