Need more rows in a crosstab query

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

Guest

I need to put more rows in a crosstab query. I could put an unlimited number
in with previous versions of Access. With 2003, I'm limited to 3 rows - any
work around? I've changed my crosstab in design view but it won't stick.
 
There is virtually no limit to the number of rows you can return in a query.

3 is definately not the case.

Post your SQL.
 
You should be able to create many more than 3 row headings in a crosstab.
If you save a query design, it should "stick". What is changing? Can you
share your SQL view and describe what isn't saving?
 
You're right. In SQL view, I could update my crosstab. I was just using the
wizard. In 2000, Access let you double click on all the fields. The wizard
in 2003 limits you to 3 rows. Using SQL view works! Thanks!!!!
 
veronica14 said:
You're right. In SQL view, I could update my crosstab. I was just using the
wizard. In 2000, Access let you double click on all the fields. The wizard
in 2003 limits you to 3 rows. Using SQL view works! Thanks!!!!
Click to expand...

Or using Query Design View works, too, and sometimes is quicker & easier
to update than SQL View.

I often use the Wizard to choose the initial settings, then switch to
Query Design View and edit it there. But specifying column headings, if
you need to do that, is probably easier in SQL View.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top