Negative numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a query, that sums a field which is based on a combo box. As it
only sums the combo boxes that are checked it gives a -1 for every input. For
each country i now have figures of -20, -63, -8 for each country.

How do I turn these into positives?

Many THanks,
Matt
 
Use the ABS function. Something like:

ABS(Sum([FieldName]))

In Access Yes or True is equal to -1 while No or False is 0.
 
Jerry Thankyou,

How would I do it where it is not a sum?
Where would the ABS go then?
Many Thanks.

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

ABS(Sum([FieldName]))

In Access Yes or True is equal to -1 while No or False is 0.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Matt Dawson said:
I have built a query, that sums a field which is based on a combo box. As it
only sums the combo boxes that are checked it gives a -1 for every input. For
each country i now have figures of -20, -63, -8 for each country.

How do I turn these into positives?

Many THanks,
Matt
Click to expand...
Click to expand...
 
Something like below should work. You may or may not need an equal sign in
front depending on where you use it.

=ABS([FieldName])
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Matt Dawson said:
Jerry Thankyou,

How would I do it where it is not a sum?
Where would the ABS go then?
Many Thanks.

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

ABS(Sum([FieldName]))

In Access Yes or True is equal to -1 while No or False is 0.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Matt Dawson said:
I have built a query, that sums a field which is based on a combo box. As it
only sums the combo boxes that are checked it gives a -1 for every input. For
each country i now have figures of -20, -63, -8 for each country.

How do I turn these into positives?

Many THanks,
Matt
Click to expand...
Click to expand...
Click to expand...
 
Thankyou, all is working
Much appreciated!

Jerry Whittle said:
Something like below should work. You may or may not need an equal sign in
front depending on where you use it.

=ABS([FieldName])
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Matt Dawson said:
Jerry Thankyou,

How would I do it where it is not a sum?
Where would the ABS go then?
Many Thanks.

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

ABS(Sum([FieldName]))

In Access Yes or True is equal to -1 while No or False is 0.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

:

I have built a query, that sums a field which is based on a combo box. As it
only sums the combo boxes that are checked it gives a -1 for every input. For
each country i now have figures of -20, -63, -8 for each country.

How do I turn these into positives?

Many THanks,
Matt
Click to expand...
Click to expand...
Click to expand...
 
Back
Top