Crosstab Help

[eerich]

Hi Everyone,

Is there a way to setup a crosstab query and just place an 'X' in the column where your criteria is met, instead of an aggregate function. I've read through the various threads but could not find anything that addressed how to setup up the TRANSFORM statement to just place an 'X' or any static value in column, instead of aggregating the data.

Appreciate any suggestions.

 

[dhookom]

For the Value, just type in an X like:
TheValue: "X"

Then use first or min or max or last.


Duane
Hook'D on Access
MS Access MVP

 

[eerich]

Duane,

I'm not sure I understand. If my syntax is something like below:

TRANSFORM First(C.ObianujName) AS ObjName
SELECT C.ObianujName, Descr

How should I construct TheValue?

Thanks for your helpl

 

[eerich]

Duane,

I believe I figured it out.

TRANSFORM First('x') as ObjVal
SELECT C.ObinujName, Descr

Thank you very much!