If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Select only negative numbered query results
Hello, just hoping for a bit of help on this one:
I have built a query which is linked via an ODBC database connection. I have added 3 linked tables to my query. In my query I have a field called "NET AVAIL". This field is a calculated field based upon the following expression: Field Input is NET AVAIL: [ON HAND] - [REQRD] Table Input is -- Blank -- Total Input is Expression The way I have this written now it querys and displays all of my records accurately, but it displays all my numbers which result in a positive "NET AVAIL" as well as a negative. I would like to filter this calculation to display on the results of this calculation which are negative. I've tried many, many different things and just can't get it. Any help is greatly appreciated! Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Visio Shortcuts | [email protected] | Visio | 1 | December 28th, 2006 11:28 PM |
Query criteria that references values of column in another table | TyzonZ | Running & Setting Up Queries | 11 | February 6th, 2006 12:57 AM |
Combining records from two queries | JohnB | Running & Setting Up Queries | 9 | January 25th, 2006 01:35 PM |
adding column with numbers in query | Giz | Running & Setting Up Queries | 15 | February 11th, 2005 11:09 AM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |