Comparing 2 columns of numbers and one column has - or + signs with numbers

[Ramesh Kumar C]

Hi Experts,

I am trying to match 2 columns and one column has numbers without any + or - sings front of numbers whereas other column has + or - signs with numbers. I want to match these 2 columns and i want to match only the numbers and ignore + or - sings front of numbers. how can i do this? Kindly advise.

[ranman256]

use absolute value in the query

Abs([field1]) = Abs([field2])

[Ramesh Kumar C]

Hi Ranman,

Its working. Thank you so much.