query- hide positive and negative equal values

[quest]

Hi:
I have a column with numbers with equal absolute values that are either positive or negative. I would like to query both them but I am only getting back one of them. I would like both to be returned when queried.


EXAMPLE:

UNIT Date


5 1/2/09
-5 1/2/09
10 2/2/09
15 3/2/09
-7 1/2/09
-20 4/2/09


Basicly, the results I would like to be is:

UNIT DATE
10 2/2/09
15 3/2/09
-7 1/2/09
-20 4/2/09


--The positive and negative equal values are taken out/hidden--
I have been using in Criteria:


NOT In (SELECT abs([UNIT])FROM [SHEET] As Tmp GROUP BY abs([UNIT]),[Date] HAVING Count(*)>1 And [Date] = [SHEET].[Date] )


The negative number is still being shown. And the positive number is hidden.
UNIT Date
5 1/2/09
10 2/2/09
15 3/2/09
-7 1/2/09
-20 4/2/09

Both of these should be hidden (numbers that cancel out):
UNIT Date
5 1/2/09
-5 1/2/09

Thanks in advance for your help.

[Rainlover]

Try Grouping by Date. Then Sum the Unit values.

The Sum of the Values should not be equal to ZERO.

PS. Date is a Reserved Word and I also think Unit is also a Reserved Word.

Try myDate and myUnit

[RuralGuy]

MVP Allen Browne maintains a pretty exhaustive list of Reserved Words.