where x > 0 AND y <0>

[Geel]

WHERE (((ResultTOrollovers.PV_rollover)>0)) OR
(((ResultTOrollovers.SAV_rollover)>0))


Hello, I'm trying to do the following: I want all the PV_rollovers that
are bigger then 0, and i want all the records that have a bigger or
smaller SAV_rollover then 0.

So if there's a zero PV_rollover but there is a bigger or smaller then
zero SAV_rollover it needs to be shown.
Same goes for if there is a zero SAV_rollover but there is >0
PV_rollover.

How can i fix this ? I tried the following:

1.
WHERE (((ResultTOrollovers.PV_rollover)>0)) AND
(((ResultTOrollovers.SAV_rollover)>0) AND
(((ResultTOrollovers.SAV_rollover)<0))

2.
WHERE (((ResultTOrollovers.PV_rollover)>0)) OR
(((ResultTOrollovers.SAV_rollover)>0))


Thx in advance,

Tim Schuffelen

 

[Douglas J. Steele]

Do you mean you want all the PV_rollovers that are bigger then 0, and all
the records for which SAV_rollover isn't 0?

WHERE (((ResultTOrollovers.PV_rollover)>0)) OR
(((ResultTOrollovers.SAV_rollover)<>0))

 

[Geel]

Douglas J. Steele schreef:

Do you mean you want all the PV_rollovers that are bigger then 0, and all
the records for which SAV_rollover isn't 0?

WHERE (((ResultTOrollovers.PV_rollover)>0)) OR
(((ResultTOrollovers.SAV_rollover)<>0))

Thanks that's exactly what i needed,

Tim