Matching positive with negative amounts

[cwert11]

Hello,

I would like to create a qry that matches the positive with the corresponding negative value. For example, $19,000 and -$19,000 would match up. Thank you in advance.

-Charles

[Ahmed Elalfy]

Dear cwert11,

You can use Absolute function:
Abs(number)

Thanks