Access Table Yes / No Field Question

[Dermot]

I have a table which incorporates a "Yes / No" field.

I have create a query based on the table which also incorporates the Yes /
No Field.

Then I created a report based on the query which also incorporates the Yes /
No Field.

Question
The report reflects the Yes / No Field as text "Yes" or "No"

Is it possible to have the report reflect the Yes condition as "Yes" and the
"No" condition as blank (No Text).

Could this be done through the validation property setting of the Yes / No
Field.

 

[KARL DEWEY]

In your query use an IIF statement like this ---
Yes_No: IIF([YourField] = -1, "Yes", "")

 

[nomadk]

In the query, create a calculated field:

YesNo: Iif([YourField]=-1,"Yes","")

and drop it in your report in place of [YourField].

 

[fredg]

I have a table which incorporates a "Yes / No" field.

I have create a query based on the table which also incorporates the Yes /
No Field.

Then I created a report based on the query which also incorporates the Yes /
No Field.

Question
The report reflects the Yes / No Field as text "Yes" or "No"

Is it possible to have the report reflect the Yes condition as "Yes" and the
"No" condition as blank (No Text).

Could this be done through the validation property setting of the Yes / No
Field.

In the report, add an unbound text control.
Set it's control source to the YesNo field.
In the Control's format property line, write:
;"Yes";"":

 

[Dermot]

Thanks for the reply fredg
Out of general interest, please advise a little further.....
Can you explain any advantages / disadvantages to modifying the report
compared to the other posting suggetions to modify the query?

Thanks in advance