Report on a Query with Yes/No data types

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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

John W. Vinson[MVP]
 
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
 
I am also trying to get the summary at the bottom of the report to give the
correct values as well.
Click to expand...

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
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top