Inverse of Absolute Values - Function to selectively create negative values

[bruegel]

I import a text file into Access (365). One of the fields is a number. Because it's a txt file it's an Absolute value. The next column signifies if it's a Credit or Debit



So:

Field 1 Field 2

Net Sign Ind

2.5 C
3.4 C
1.6 D

Is there a function I can use in a query to create a negative using the Sign Ind Value please?

Field 1 Field 2 Field 3

Net Sign Ind New Net

2.5 C 2.5
3.4 C 3.4
1.6 D -1.6

Thanks for the help (Will repost below if this comes out jumbled)

Pieter

[Minty]

A simple IIf() would do it in a query

NewValue: IIf([Sign] = "D", [Net] *-1, [Net])

[bruegel]

Thank you

I was being way too clever for my own good

Pieter