Query Expression Show Only <0

[PerryC]

I have a siimple? problem:

In Access 2002 query, I have say 3 columns: X Y Z=x-y

How do I get z to show only if value <0 if there has been expression
added to Z

i.e.
x y z: [x]-[y]
Expression Min Expression

I am pulling my hair out over this, seem simple task. But access just
won't show only those z value that is <0.

Please help.

Thanks,
Perry

[MLH]

This should work:
SELECT DISTINCTROW Sit.one, Sit.two, [one]-[two] AS Three FROM Sit
WHERE ((([one]-[two])<0));

Sit.One and Sit.Two are table fields (integer type)

cccccccccccccccccccccccccccccccccccccccccccccccccc cccccccccc

On 28 Jan 2004 14:42:13 -0800, pe******@yahoo.com (PerryC) wrote:

I have a siimple? problem:

In Access 2002 query, I have say 3 columns: X Y Z=x-y

How do I get z to show only if value <0 if there has been expression
added to Z

i.e.
x y z: [x]-[y]
Expression Min Expression

I am pulling my hair out over this, seem simple task. But access just
won't show only those z value that is <0.

Please help.

Thanks,
Perry