Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: can anybody help me on charts

    can anybody help me
    i have a table as shown in below
    Department supplier Monat ERR OK
    EADP EAP January 32 56
    EADP EAXY January 54 50
    EAp EAS January 45 45
    EADP EAP February 32 56
    EADP EAXY February 54 50
    EAp EAS February 45 45
    now with this table i want to draw some pivot chats in form
    1. with dapartment, ERR, OK pie diagram monthly
    i want january and february in different pages ie., i want to insert a combo box for month if i change in the combo box the month the results in the form should appear for that month only.

    2.with dept ERR as column chart with the same phenomenon if i change the month only results should come for that month.

    i have tried but its asking a popup menu for month to display but i need in diffrent form as i explained, i change in the combo box the month particular month results should get

  2. #2
    Join Date
    Oct 2003
    This sounds like a parameter problem. Did you put your parameter into the Parameter form (in design view of the query, choose Parameters from the Query pull down menu)? Does it work if you hard code the month? I am trying to figure out if it is a query problem or a form problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts