Crosstab Row Heading Issues - Limited to max 3 field values

M

mike

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
 
J

Jerry Whittle

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