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