Category Axis

  • Thread starter Thread starter Tloliver79
  • Start date Start date
T

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;
 
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.
 
Back
Top