create a chart from a query in report

[Guest]

I have created a chart from a query & inserted into a report.
when report opens I am asked for query select (which is correct) report
table is displayed but chart is blank?
what have i missed?

 

[Duane Hookom]

"I am asked" sounds like a parameter prompt query. You should use a
reference to a control on a report rather than the prompt.

Are there any values in your Link Master/Child properties?

 

[Guest]

Link Master/Child properties?
(Novice here)

"I am asked" sounds like a parameter prompt query. You should use a
reference to a control on a report rather than the prompt.

Are there any values in your Link Master/Child properties?

 

[Guest]

The query is a select query. I now receive a error message that microsoft jet
data base does not recognise '(my select query name )' as a valid field name
or expression.
The query runs ok though.
I created the chart via chart wizard.

 

[Duane Hookom]

A chart control has several properties including: Row Source, Link Master
Fields, Link Child Fields. If you are having trouble with your chart, please
reply with the values of these properties.

 

[Guest]

Row source = TRANSFORM Sum([%]) AS [SumOf%] SELECT [Clock] FROM [Plan 5*
Query % chart] GROUP BY [Clock] PIVOT [PlanID];

Link fields are not a option as it is OLEUnbound

 

[Duane Hookom]

The Row Source is a crosstab query which requires you to enter the data
types of all parameters. Select Query->Parameters and enter your parameters
and data types.

I don't think I have seen a chart control that doesn't have Link
Master/Child properties.

--
Duane Hookom
MS Access MVP

Row source = TRANSFORM Sum([%]) AS [SumOf%] SELECT [Clock] FROM [Plan 5*
Query % chart] GROUP BY [Clock] PIVOT [PlanID];

Link fields are not a option as it is OLEUnbound

A chart control has several properties including: Row Source, Link Master
Fields, Link Child Fields. If you are having trouble with your chart,
please
reply with the values of these properties.