Cross tab report

[wnicole]

I'm running a cross tab report. This is based on certifications. If they have one the current column has X.



Cert1 Cert2 Cert3
Jane Doe X X
John Smith X

However when I run the report its Counts. Which turns the X into 1

In the query can I select Expression or something of that sort instead of Group By, Count.

I don't know how to get it to return my text and now Count it.
Any help appreciate it.

[June7]

You can select First or Last. That will return the text value.

[wnicole]

It worked thanks!!!