Convert Yes/No data type to YES NO not -1 or 0

[Yardyy]

Hi, I have a type YES/NO type field, which when previed in a report, i get a -1 for YES and a 0 for a NO. Does anyone know how i can get it to Print YES or NO on the report when i either one is selected..

Many Thanks
Yurov Ardyy

 

[Spenney]

The format property of the text box can be set to "Yes/No", "True/False" or "On/Off". It sounds like you don't have a format set.

 

[Yardyy]

Just checked it, and it is set on the main table, but found that the make table query that i have setup, which creates a new table and the report is generated of does not set this value, when the query is triggered.

Is there anyway that i can change the values on all this fields at once, as there is about 16 in this one table that gets created. Under format of this field, it is just blank.. !

Many Thanks
Yurov Ardyy

 

[Spenney]

I was referring to the properties of the text box on the report. As long as the data type of the field remains as "Yes/No" in the table, it shouldn't matter what else the make-table query does to the field - the text box on the report, if formatted as described above, will show Yes or No.

Is the make table really necessary? Wouldn't a simple select query do the job?

 

[Yardyy]

Sorted it, thanks.. wouldnt have done it without you..

I need the make table query as i need to print of a 7 page report, and dont know of any other way to capture the data to put into this report.

i only have one table, with about 60 fields in it, but i need to print of only the current record, make table was the easiest option, but now am finding some issues with it, but you sorted that for me, so thanks again.

Many Thanks
Yurov Ardyy

 

[randy700]

dont know of any other way to capture the data to put into this report

What about a SELECT QUERY?


Randy