Charts in Access 2007

[dealwi8me]

Hello,

I'm trying to build a chart in a report but it seems that I'm doing something wrong

I need a chart that shows comparison of an item prices that different sellers sold

Here's my query:

SELECT tblItem.ItemID, tblSeller.SellerID, tblSeller.PriceS, tblItem.PriceB
FROM  tblItem INNER JOIN tblSeller ON tblItem.ItemID = tblSeller.ItemID

The results of the query are the following:
(1,1,45,30
1,2,30,30
1,3,56.5,30)

Any suggestion in how should i build the chart?

Thank you in advance.

 

[here4real]

I know it has been a while since you posted this but I am having exactly the same issue... Did you find out how to do it???