access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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