Y/N Field

[DavidCantor]

How do I get the YN field to return a 1 for Y (and not -1!!) and a 0 for N?

 

[gemma-the-husky]

True IS minus 1.

why do you want it to be 1, instead. what are you trying to achieve. Managing the data is a different issue.

 

[DavidCantor]

I need the data to show either 1 if Yes is selected or 0 for No

 

[boblarson]

You can use

Abs([FieldName])

But it won't be updateable.

 

[gemma-the-husky]

you can configure the database to show TRUE, YES, or a tickbox

you can manipulate it to show +1 - but it is actually stored as -1. It just IS, in this language.

There are other things you can do - If you want to count the number of "true" values - that is a different matter, and very easy.

Hence the question about why seeing a figure 1 is so critical

 

[DavidCantor]

How do I manipulate the field to show 1 and not -1? I do not need to count the values I just need the form to show 1 when True is selected for that field.

Thanks

 

[boblarson]

How do I manipulate the field to show 1 and not -1? I do not need to count the values I just need the form to show 1 when True is selected for that field.

Thanks

Already gave you the answer;

You can use

Abs([FieldName])

But it won't be updateable.