Crosstab or Pivot Table without numbers
Posted on 2014-04-25
I'm trying to create a crosstab query in MS Access that would show only character values instead of numbers as values. The query is supposed to show a rating (e.g. H, M or L) as values for each risk (rows) and departments (columns). The table driving this crosstab query doesn't have duplicate department/risk combination. I haven't been able to do this with pivot tables/cross tab query because it only seem to allow numbers as values. Any ideas?