ReverseSign Property

Changes negative values into positive values and positive values into negative values in a column of a resulting query dataset.

Applies to

Query columns


The ReverseSign property applies only to columns that have a numeric data type. If you set the ReverseSign property on a column that does not have a numeric data type, you will get an error.

Property Value

Yes to reverse the sign of column values; otherwise, No. The default is No.


Field values in a database table can be negative numbers, as well as positive. For example, credits are typically stored as negative values to deduct them from the overall balance due. However, for displaying purposes, such as in spreadsheets and charts, you might want these quantities to appear as a positive numbers.

See Also

How to: Create Queries