Report on a Query with Yes/No data types

[Guest]

Hi

I am trying to get a report to run on a query that gets it's records from a
table with Yes/No data types in it.

When I preview the report or look at the query content, the Yes/No data
types return a numeric value, either -1 or 0. Is there anyway to change the
report/query output so that the correct Yes or No responses are returned?

Thanks

 

[Duane Hookom]

Change the format property of the report controls to display yes/no
Format: Yes/No

 

[John Vinson]

Hi

I am trying to get a report to run on a query that gets it's records from a
table with Yes/No data types in it.

When I preview the report or look at the query content, the Yes/No data
types return a numeric value, either -1 or 0. Is there anyway to change the
report/query output so that the correct Yes or No responses are returned?

Thanks

Use a Report; set the Format property of the textbox bound to the
yes/no field to "Yes/No".

John W. Vinson[MVP]

 

[Guest]

Thanks

I am also trying to get the summary at the bottom of the report to give the
correct values as well.

The statement is here:

="Summary for " & "'Charity Informed' = " & " " & [Charity Informed] & " ("
& Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"

Where [Charity Informed] is the Yes/No data type. This currently returns
either -1 or 0

Thanks Again

 

[John Vinson]

I am also trying to get the summary at the bottom of the report to give the
correct values as well.

It is giving the correct values... just not in the format you want to
see! The value stored in a table *IS* -1 for Yes, and 0 for No.

The statement is here:

="Summary for " & "'Charity Informed' = " & " " & [Charity Informed] & " ("
& Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"

Where [Charity Informed] is the Yes/No data type. This currently returns
either -1 or 0

="Summary for 'Charity Informed' = " & IIF([Charity Informed], "Yes",
"No") & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail
records") & ")"

John W. Vinson[MVP]