cross tab sort order

[inungh]

I would like to have my cross tab query to sort by user option.

For example, the Crosstab query result has field1, Field2, and field3.


I would like to have my program to give user option to sort by any
field.

Are there any way to sort crosstab query?


Your help is great appreciated,

 

[KARL DEWEY]

You can have an option group on a form to make a selection. Then in a select
query use an IIF function to pull a prefered field for an output column to be
used as first Row Heading in the crosstab query.

If you need further explaination then post your crosstab query that includes
all of the fields.

 

[inungh]

You can have an option group on a form to make a selection.  Then in a select
query use an IIF function to pull a prefered field for an output column to be
used as first Row Heading in the crosstab query.

If you need further explaination then post your crosstab query that includes
all of the fields.
--
KARL DEWEY
Build a little - Test a little









- Show quoted text -

Thanks millions,