Pivot table/chart problem (see attached)

[morlan]

I having a problem with my PivotChart.

Instead of the chart displaying the SalesExec name and Country name it only diplays the lookup ID of the names.

I have a book on access that mentions the problem but doesn't explain how to resolve it.

Can somebody point me in the right direction.

Thanks

 

[KKilfoil]

Your problem is with the way you are attempting to replace the Foreign Key (FK) numeric values with the Lookup values from the related tables.

Have a look at the attached mod to your db.

You added lookups in your TABLE design view. This simply changes the way Access SHOWS you the data, showing the lookup text rather than the FK integer value, but the STORED value is the actual INTEGER value of the FK

When you created your query, the lookup text appeared to 'ripple' to the query, but the actual returned values in the query is the integers, which is what the chart showed you.

Have a look at what I did, which was to construct a query returning the actual text values from the approprate tables. Look at the SQL view to get an idea what is really happening.

HTH

 

[morlan]

Thanks mate!

That does the job thanks