access query

L

lawsongs

I have a query in my database which includes the following fields from
various tables:
orderID
stockID
qty
price
stockLevel
reorderLevel
However I cant figure out how to display only the results where 'stockLevel'
is less than 'reorderLevel'.
 
O

Ofer Cohen

Try this SQL after changing the table name

Select orderID, stockID , qty, price, stockLevel, reorderLevel,
From TableNAme
Where stockLevel < reorderLevel

Or, write under the stockLevel field the criteria
< reorderLevel
 
Top