By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,798 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

Query Expression Show Only <0

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.