C

#### ComTech

value of and so far no syntax I have tried has been successful. The field is

populated with both positive and negative numbers. I simply need to convert

these to a positive number for my further calculations. Consider the field

in question as MyTable.MyField which is a Number - Long Integer.

I tried this by creating a Make Table Query and used the Expression Builder

to create the desired results. Unfortunately I am not a visual basic or SQL

language expert by any means. The vast majority of these values are negative

numbers. If at worst case I had to just multiple everything by -1 then I

could deal with the few isolated negatives that would create. Below are a

couple of example of what produced zero results in my query.

[MyTable]![MyField]*-1

Abs ([MyTable]![MyField])

I would appreciate any ideas. Thanks in advance.