Results 1 to 3 of 3
  1. #1
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55

    graphs on a report

    Hi guys
    here is my latest headache.
    On my database I have a report that runs from a query which uses a prompt in the criteria to filter the information that is required to populate the report. I have also made a graph that uses the same information to populate the graph. So the report should have the written information and the same information in visual form.
    The problem I'm struggling to overcome is that because the prompt in the criteria is used in the query when the report is opened the prompt asks for the information you want the report based on and after entering this it fills in the data on the form then puts up the prompt again .If I fill it in it draws the graph.
    Is there a way of linking the graph and the data so that I only fill in the info into the prompt once?
    Hope that makes sence

  2. #2
    JamesDeckert is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    Can you post your query?

  3. #3
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55

    Graphs

    Hi thanks for the reply I hope Ive managed to attaché a basic table and two query's and a report that hopefully show the problem. example.zip
    Attached Files Attached Files

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

Similar Threads

  1. graphs
    By chr1stoper1 in forum Access
    Replies: 3
    Last Post: 08-08-2015, 11:11 AM
  2. Replies: 3
    Last Post: 11-23-2013, 09:00 AM
  3. Report Graphs
    By dr4ke1990 in forum Reports
    Replies: 9
    Last Post: 10-26-2013, 11:29 AM
  4. Report Graphs
    By RayMilhon in forum Reports
    Replies: 2
    Last Post: 03-16-2012, 02:02 PM
  5. Graphs
    By thewabit in forum Forms
    Replies: 1
    Last Post: 01-17-2010, 10:52 PM

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