Adding chart to a form showing inventory value

[mayapredco]

I am doing a project for a class and I have to add a chart embedded in a form depicting the total value per item. I'm not sure how to do this.



We were given an inventory with the price, so to find the total value so I made an Inventory Value table where I multiplied the quantity by the price. Now I don't know how to insert a chart onto the form (ACase02step8 is the name of the form). I attached the database below because I think that will help to show what I'm trying to do.

The exact instruction for this step was

"Create an Outlet and Inventory Item Data form. The main part of the form is the Outlet and its address. Embedded on the form in datasheet view the Item ID, Quantity on Hand, Item Description and Price for each outlet. Embedded on a separate tab of the same form provide a graph of the total value per item."

I have everything except the last sentence.

Thanks

[June7]

You want the chart to show value of inventory at the outlet that is the current record of the form? I have never put a chart on a form, only reports. Here is how I go about it.

Start by dragging a chart control to the tab page. Build chart with the wizard, doesn't have to make sense, just get the control established and edit chart later.

Set chart RowSource property to a query that joins the Inventory and Inventoy Value tables:
SELECT Inventory.[Item ID], [Price]*[Inventory].[Qty on Hand] AS InvVal
FROM [Inventory Value] RIGHT JOIN Inventory ON [Inventory Value].[Item ID] = Inventory.[Item ID]
WHERE (((Inventory.[Outlet ID])=[Forms]![ACase02step8]![Outlet]));

I have yet to figure out the Master/Child linking of charts so I use the WHERE clause of the sql.

Edit other chart features (labels, titles, legend): select the chart and right click > Chart Object > Edit.

BTW, there is an inventory item in Inventory that is not in Inventory Value: T1587.