Query fields

A

Amateur

How can I change a negative number in a query i.e. ($800.00) into a positive
number i.e. $800.00 without using a formula like -$800.00+($800.00*2). Is
there a posibilty to format a negative number into positive?
 
A

Amateur

Hi Kevin
thanks, but where should I insert that?
Thanks
Klaus

Kevin B said:
How about [FieldName]*-1 to produce your positive number.
--
Kevin Backmann


Amateur said:
How can I change a negative number in a query i.e. ($800.00) into a positive
number i.e. $800.00 without using a formula like -$800.00+($800.00*2). Is
there a posibilty to format a negative number into positive?
Click to expand...
Click to expand...
 
A

Amateur

Never did this - can you explain a bid more?
Where would I insert: The Value: Abs([commissionF])
Thanks
Klaus

Jerry Whittle said:
Use the ABS() function. Something like:

TheValue: Abs([TheFieldName])
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Amateur said:
How can I change a negative number in a query i.e. ($800.00) into a positive
number i.e. $800.00 without using a formula like -$800.00+($800.00*2). Is
there a posibilty to format a negative number into positive?
Click to expand...
Click to expand...
 
C

Charles Calvert

How can I change a negative number in a query i.e. ($800.00) into a positive
number i.e. $800.00 without using a formula like -$800.00+($800.00*2). Is
there a posibilty to format a negative number into positive?
Click to expand...

Look up the function Abs().
 
K

Kevin B

YOu would create a custom field in your query by doing the following:

1. Select the query and open in Edit Mode

2. In a blank column of the query name the custom column, follow the name
with a colon and then the equation

CustomColumnName:[FieldName]*-1

You can than refer to the custom field by its name when you want to view it
in a report or form.
--
Kevin Backmann


Amateur said:
Hi Kevin
thanks, but where should I insert that?
Thanks
Klaus

Kevin B said:
How about [FieldName]*-1 to produce your positive number.
--
Kevin Backmann


Amateur said:
How can I change a negative number in a query i.e. ($800.00) into a positive
number i.e. $800.00 without using a formula like -$800.00+($800.00*2). Is
there a posibilty to format a negative number into positive?
Click to expand...
Click to expand...
Click to expand...
 
Top