Right now I have a field named "State" in a query that is based off of a yes/no field. When I put this field in a report, I want to see a capital "Y" if the yes/no field is checked, and I want a null value returned if the yes/no field is not checked.
My thought was to add another field to the query then place that field in the report instead of the field called the Yes/No field. I named this new field "ReportField" and tried using an IIF statement. But whenever I run the query, it asks for the paramters of "Y" (the value I want to show up when the yes/no field is checked to true). My syntax is: IIF( [State] = True, "Y", "")
How can I change that to get my desired result? ( the four quotes after the second comma indicate the null value, or at least my attempt at a null value)
My thought was to add another field to the query then place that field in the report instead of the field called the Yes/No field. I named this new field "ReportField" and tried using an IIF statement. But whenever I run the query, it asks for the paramters of "Y" (the value I want to show up when the yes/no field is checked to true). My syntax is: IIF( [State] = True, "Y", "")
How can I change that to get my desired result? ( the four quotes after the second comma indicate the null value, or at least my attempt at a null value)
