Re: Need more rows in a crosstab query

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

"veronica14" <veronica14@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B518959A-3E0D-48EB-9FB9-C6CA6DB92FDA@xxxxxxxxxxxxxxxx
>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.


.

Relevant Pages

  • Re: Form Based Cross Tab Query
    ... > one of the tables used in the Query. ... >>Duane Hookom ... >>MS Access MVP ... >>> Does this approach not work using a crosstab query? ...
    (microsoft.public.access.queries)
  • Re: date parameter and crosstab query problem
    ... >> Duane Hookom ... >> MS Access MVP ... >>> I created a crosstab query. ... >>> The crosstab query is perfect but I need to run this query every week ...
    (microsoft.public.access.queries)
  • Re: Incrementing nrs in a query
    ... > unless you are familiar with VBA, and calling functions from a query. ... > Steve Clark, Access MVP ... > FMS, Inc. ...
    (microsoft.public.access.queries)
  • Re: [OT] Reusable Query
    ... > Steve Clark, Access MVP ... > FMS, Inc. ... >> into the query where I would normally put the form name? ...
    (microsoft.public.access.queries)
  • Re: Reusable Query
    ... Steve Clark, Access MVP ... "cvegas" wrote in message ... > into the query where I would normally put the form name? ...
    (microsoft.public.access.queries)