Using Graphs in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have some problems by using graphs in my access reports.

I have a table, with the following columbs.
ID_auto, ID, Year, Md ,value.

1,15,2005,1,1
2,11,2004,11,2
3,15,2005,2,4
4,13,2006,1,9
......

I have made a report which shows data by using groups
----------------------
Report
----------------------

ID:15
Year:2005
Md, Value:1,1
Md, Value:2,4

Then I want the data to be shown i a bar-graph.
I tell the graph-guide to combine the

a) "report ID" with the "diagram ID"
b) "report year" with the "diagram year"

Now the graph gives me data for the right ID, but it gives me data for all
the years.

I only want it to show me data for one year(the year shown in the rest of
the report).

How can I do that?

Best Regards
Peter
 
in the property window of your graph while in the design view of your report
select this property

link child field
link master field

these fields if access puts them in..... can be inputted incorrectly. enter
the fields you want to link. the master is the report and the child is the
graph,
input the fields using " ; "
to join the fields like "year;Month" in child
and "year;Month" in master


Rivers868
 
Back
Top