How to display an "x" or checkbox in place of text result

[Guest]

I have a query with where one field is either "a" "b" or "c". How do I use a
query or report to display an "x" in one column for a, "x" in another column
for b, and another one for c? Should this be done in the query of report?

Response is appreciated.

 

[fredg]

I have a query with where one field is either "a" "b" or "c". How do I use a
query or report to display an "x" in one column for a, "x" in another column
for b, and another one for c? Should this be done in the query of report?

Response is appreciated.

You can do this directly in a report.
Use 3 unbound text controls. Set it's control source to:
=IIf(FieldA] = "A","X","")
or
=IIf(FieldB] = "B","X","")
or
etc.

 

[Guest]

You can do it in a query then use the query in a report.
In query design view add a new column like this --
Apples: IIf([YourTextField] = "a", "X","")
Next column --
Bananas: IIf([YourTextField] = "b", "X","")
Next column --
Carrots: IIf ............ you get the picture.