Crosstab Row Heading Issues - Limited to max 3 field values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have Access 2003 and when I do a cross tab I cannot bring in more than 3
field values for row headings - my coworker (who has Access 97) can bring in
3 row headings. Is this a paremter setting in Access 2003?
Click to expand...

Thanks,
Mike
 
I believe that the Wizard can't handle more than 3; however, you can do more
with SQL. Try creating a crosstab with the three headings, them modifying it
at SQL level to add more.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max length of Column Heading in Crosstab 3
Crosstab Qry-Add Rows & Columns 2
Crosstab Loosing shape 1
cannot use the crosstab of a non-fixed column as a subquery 3
Crosstab Query Row Heading 4
Crosstab Query Column headings 4
Row Headings in a Crosstab Query 2
criteria in crosstab query 1

Back
Top