Changing From - to +

[pgilbert11]

I have a table full of YES/NO fields.
When the field is checked it gives a value of -1.
Can anyone tell me whether it is possible to change that so it gives a value
of 1 when checked and how to do it.

Thanks
Paul

 

[Graeme Richardson]

Hi Paul, if your looking for a visual indicator [non editable] on a form set
the TextBox ControlSource to
=Abs(myFieldName)
or
=Abs(myControlName)

If you want to edit the field then consider using a ConboBox with
properties:

ControlSource: myFieldName
RowSourceType: ValueList
RowSource: -1,1,0,0
ColumnCount: 2
ColumnWIdths 0cm

HTH, Graeme.

 

[pgilbert11]

Hi Graeme

Not quite what i'm looking for.
When i run a query on the table with the YES/NO fields, i sum all the fields
in a table.
This gives me a value but it is displayed as a - value.
What i wanted was to get rid of the - symbol.
This is so when i run a report on this query the resulting figures show
numbers without the - symbol.
Any ideas.

Paul

 

[pgilbert11]

HI

Found alternative means.
Thanks for help

Paul

 

[Rick Brandt]

Hi Graeme

Not quite what i'm looking for.
When i run a query on the table with the YES/NO fields, i sum all the
fields in a table.
This gives me a value but it is displayed as a - value.
What i wanted was to get rid of the - symbol.
This is so when i run a report on this query the resulting figures
show numbers without the - symbol.
Any ideas.

The Abs() function DOES get rid of the negative sign.

 

[Graeme Richardson]

Try
=Abs(Sum(myFieldName))

Graeme.