crosstab query without calculations

  • Thread starter Thread starter inungh
  • Start date Start date
I

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,\
 
Need a little more information on what you want to achieve. Post sample of
input data and reults you want to see.
 
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
 
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
 
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 -
Click to expand...

Thanks millions for helping,
 
Back
Top