access query

[Guest]

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'.

 

[Guest]

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