crosstab error

[mike via AccessMonster.com]

hi,

Im getting error "too many crosstab column header (2077)" on my crosstab
query..heres the SQL

TRANSFORM Sum(QryGerald.QtyOnHand) AS SumOfQtyOnHand
SELECT QryGerald.MRN_No, Sum(QryGerald.QtyOnHand) AS [Total Of QtyOnHand]
FROM QryGerald
GROUP BY QryGerald.MRN_No
PIVOT QryGerald.Location;

Any help is appreciated...

mike

 

[Duane Hookom]

You have too many possible location values. You need to group these into
"super locations" or filter out some of the locations.

 

[mike via AccessMonster.com]

Duane,
Thanks for ur reply,, can you teach me how to do this?

mike

You have too many possible location values. You need to group these into
"super locations" or filter out some of the locations.

hi,

[quoted text clipped - 10 lines]

mike

 

[Duane Hookom]

To filter for less columns, use something like:

TRANSFORM Sum(QryGerald.QtyOnHand) AS SumOfQtyOnHand
SELECT QryGerald.MRN_No, Sum(QryGerald.QtyOnHand) AS [Total Of QtyOnHand]
FROM QryGerald
WHERE Location Between "A" and "M"
GROUP BY QryGerald.MRN_No
PIVOT QryGerald.Location;

This wouldn't seem to have much value but you haven't helped us out here
with what you want to see.
--
Duane Hookom
MS Access MVP
--

Duane,
Thanks for ur reply,, can you teach me how to do this?

mike

You have too many possible location values. You need to group these into
"super locations" or filter out some of the locations.

hi,

[quoted text clipped - 10 lines]

mike