Inserting a query into an access report

[maxcrook]

I need to insert a field into the header of an access report chart. how do I go about doing this the query is
written in the same database

 

[JoeMiller]

I don't understand the question, what do you mean you need to insert a field? A field with what, the query name? a value? a list of values? Examples/table names/query names/field names/etc... are helpful.

Joe Miller
joe.miller@flotech.net

 

[maxcrook]

apologies.....I have created a chart report within access that is created from a query in the database, however I need to have an variable header on the chart report, this field is taken from a query.

1.I select the query for the record source data property of the report.

2.I select the field from the control source in the data property.

Both points above work successfully however......

Multiple pages of the same chart are created. How can I stop this from happening

 

[JoeMiller]

What question are you asking?? How to insert a variable or how to stop the repeating chart?!

Variable: Is it a global variable? Is it a variable on a form? If it's on a form is the variable public? Is it a variable in the current report? Is it a parameter in a query? All these have slightly different answers.

Repeating: Did you use the wizard or is this hand crafted? I suspect it's hand crafted so you shouldn't have a record source for the report, you should have a row source for the chart object. Try making your chart with the wizard and see how the wizard does it. Joe Miller
joe.miller@flotech.net