Negative vs Positive Numbers

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

Guest

I have a MS Excel worksheet I have to work with that has both POISTIVE and NEGATIVE numbers in the same column. I want to have them "Cancel Each Other Out". Currently I have to do it manually. I would like to import it to MS Access so I can "do more things". Any help would be appreciated.
 
What does "Cancel Each Other Out" mean?

Say, there is table that likes like:

Field1 Field2
AAA -1
BBB 2
CCC -3
DDD 5

Then what will happen by "Cancelling Each Other OUT"?

Note, table in Access does not do anything except for storing data, which is
different from Excel. Any cmputing process is done through Form, Query and
VBA code.

Mike Powers said:
I have a MS Excel worksheet I have to work with that has both POISTIVE and
Click to expand...
NEGATIVE numbers in the same column. I want to have them "Cancel Each Other
Out". Currently I have to do it manually. I would like to import it to MS
Access so I can "do more things". Any help would be appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching Negative and Positive Values 20
converting positive number to negative 2
Working with negative numbers. 3
Reallocate array cells value from positive to negative 0
Report Ignoring negative numbers 7
Change values to negative amounts? 3
Calculate Rate of Change Formula 6
Help with positive and negative numbers 1

Back
Top