title: Simple MS Access crosstab query with lookup column
body: <p>I have a simple MS Access crosstab query question. I have a table with the following fields:</p>
  
  <p>Name, category, number</p>
  
  <p>And want to do a crosstab with name as row header and category with column header. Category is defined as a text field in the database and has a defined lookup value.</p>
  
  <p>If I run a simple select query, everything looks fine, but if I run a crosstab query I get numbers as column headers. Does this have something to do with the lookup definition?</p>
  
  <p>Any ideas? Thanks in advance.</p>