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.
 
Back
Top