crostab query

[ken]

Hi,
I have a crostab query which does a count calculation. Everytime there
is a crosreference between a given row heading and a column heading I
get a count of how many crossreferences there are. Is there a way of
instead of getting a count I could have an X display? I tried putting
an if statement in the field cell of the value column(as seen from
design view), but I got a datatype mismatch when trying to run the
query?

Thanks

Using A2k

[David Lloyd]

Ken:

The following simple crosstab does put an X in place of the count. If this
approach does not work for you, maybe you can provide some additional
details of your crosstab query as well as the data types involved. As your
error is related to data types, knowing this information would be helpful.

TRANSFORM IIf(Not IsNull(Count([Field2])),"X","") AS MyField
SELECT TEST2.Field1
FROM TEST2
GROUP BY TEST2.Field1
PIVOT TEST2.Field2;

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"ken" <ge****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi,
I have a crostab query which does a count calculation. Everytime there
is a crosreference between a given row heading and a column heading I
get a count of how many crossreferences there are. Is there a way of
instead of getting a count I could have an X display? I tried putting
an if statement in the field cell of the value column(as seen from
design view), but I got a datatype mismatch when trying to run the
query?

Thanks

Using A2k