Access Report Grouped Blank Graph / Chart

[pzaccess]

thread703-1551246

My table:
Application, Month, Type, Hours

I have a report that displays a sum of Hours by Month and Type - grouped by applications. Works fine. I need to display the same data in an area chart.

I created a graph using the wizard (placed under the "Application Footer". I used Application for Link Master Fields and Link Child Fields.

The row source: TRANSFORM Sum([Hours]) AS [SumOfHours] SELECT [MonthName] FROM [Table1] GROUP BY [MonthName] PIVOT [Type];

When I run the report, the chart is blank - just the title is shown.

I referenced Duane Hookom example

http://www.access.hookom.net/Samples.htm

for report w/chart using 2 link fields. I attempted to re-create it by setting up an exact same table, same report, same graph in a separate database - I couldn't get it to work - same result with blank charts. However, when I create another report in Duane's database off his data - it works great.

Is there a special way to setup the data or to set the database parameters to resolve this issue with the chart? BTW, if I remove "Link master/child fields" the graph displays - but obviously not by group (application).

THANKS!

 

[dhookom]

My data was magic data ;-)

Can we assume table1 has the Application field? Have you considered changing the name of the field (at least in the report's record source and chart's Row Source)? Application is a reserved word.


Duane
Hook'D on Access
MS Access MVP

 

[pzaccess]

Duane, thank you for your help! Changing the field name from Application to App did the trick - it works fine now. Do you know of a good refernce that lists all of Access reserved words?

Thanks again!

 

[dhookom]

Sorry, I should have posted my source Allen Browne's Problem names and reserved words in Access

Duane
Hook'D on Access
MS Access MVP