Results 1 to 2 of 2
  1. #1
    mayapredco is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5

    Adding chart to a form showing inventory value

    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
    Attached Files Attached Files
    Last edited by mayapredco; 04-21-2012 at 06:10 PM. Reason: Wrong database

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Scatter Chart not Showing X-axis Values
    By ward0749 in forum Forms
    Replies: 4
    Last Post: 03-20-2012, 06:37 AM
  2. Adding a chart to a report
    By Bigmix in forum Reports
    Replies: 7
    Last Post: 02-14-2012, 08:47 AM
  3. line chart not showing lines
    By ajetrumpet in forum Reports
    Replies: 0
    Last Post: 09-11-2010, 05:55 PM
  4. Replies: 2
    Last Post: 07-12-2010, 05:39 AM
  5. Design view not showing data (Pivot Chart)
    By thestappa in forum Reports
    Replies: 0
    Last Post: 06-24-2010, 09:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums