How do I split a crosstab query?

[liselle]

Hi,

I am not sure that I even asked this question correctly - but my problem is that I have too many records in a crosstab query and I do not know how to effectively split it. I can possibly just do some at a time, but I don't want to limit the query - that is - if more pieces of the equipment are added, I can end up with part of the query still haveing too many records to do a proper crosstab query. Any suggestions??

Thanks for any help I can get.

 

[The Member]

I am not sure if this is what you would want, but you can gointo the design view of the Xtab queries and limit the "column head"s to your liking. Say at the table view you have column "a", "b" and "c". If you only want to have column a and b, you can limit it by putting ""a" and "b"" in the "Criteria" in the design view.

When a new column head added since you limitted the Criteria to a and b only, it should not display anything else, and not the new column head.

I hope this is not too confusing...

 

[Rich]

Download the qrySamp from MS it has several useful examples.

 

[liselle]

Thanks for your replies - I am about to download the examples. The thingis as well that I do need all the results to be returned to me - so even though I can limit the number of columns by the criteria - I still want all the results returned.

 

[Pat Hartman]

If you want to split the crosstabs to a more manageagle width, add a parameter. That way you can run them once to select valuse x through y and again to select values a through b.

Don't forget, in a crosstab query, you must declare parameters explicitly (they must have been written by a different programmer since other query types do not have this requirement

).

 

[liselle]

Thanks for your response - I am now just trying to figure out how best to use the parameters. I cannot prompt the user for the values - I will have to split it up myself because they are queries on quite a great number of pieces of equipment. Thanks again