Category Axis

[Tloliver79]

I have a chart in access and my category axis is showing numbers instead of
the category name. When I open the row source it shows up as the category?

TRANSFORM Count(DeptCnt_qry.CATEGORY) AS CountOfCATEGORY SELECT
DeptCnt_qry.DEPT FROM DeptCnt_qry GROUP BY DeptCnt_qry.DEPT PIVOT
DeptCnt_qry.Quality;

 

[Duane Hookom]

Apparently you have fallen into the trap of using a lookup field defined in a
table. Your Row Source query must include the table and field that actually
stores the department name. The current Dept field is only a number. The
lookup fields fool you into thinking the "name" field is available when it
isn't.