Switch Function

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I am using the switch function in a crosstab query to
define my column headings. My query changes the headings
for 52 columns. (I know that is alot). The problem is I
get an error that the query is too complex once I get over
16 columns. It works fine with less columns. I have
shortened the field names, etc but apparently there is a
limit of 1024 in the design grid. Any ideas how I can
overcome my problem? Thanks.

Pam
 
52 switch expressions? Can't you model this with data? I think you should
provide a sample. At the very least, you should be able to create a simple
function that return the proper value.
 
Yes, I don't need the switch expression. What a
difference a day makes. It was a long day yesteday and I
didn't see the forest thru the trees. Thanks for your
help.

Pam
 
Back
Top