crosstab query without calculations

[inungh]

I would like to have crosstab query and only needs to tranform without
calculations. I just wonder that should all crosstab need formular
like count, sum, max and min like group query?

Are there any option that I just need convert the result without
calculations?


Your information is great appreciated,\

 

[KARL DEWEY]

Need a little more information on what you want to achieve. Post sample of
input data and reults you want to see.

 

[John Spencer MVP]

That is a bit vague, but you might try FIRST or LAST as the operator.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[ken]

If there is only one value to be taken into account at each
intersection of the row and column headings you can use any
aggregation operator. I tend to use the MAX operator in this sort of
situation, but any will do.

Ken Sheridan
Stafford, England

 

[inungh]

If there is only one value to be taken into account at each
intersection of the row and column headings you can use any
aggregation operator.  I tend to use the MAX operator in this sort of
situation, but any will do.

Ken Sheridan
Stafford, England





- Show quoted text -

Thanks millions for helping,