Minimum quanity Query question

  • Thread starter Thread starter James Mckillop
  • Start date Start date
J

James Mckillop

I am trying to write a Query that looks at two fields and
then then reports when field 1 is less then field 2. It
is a report that tells when to order parts. I have set
up field 1 to be QTY_on_Hand and Field 2 to be Min_Qty.
My Query has all fields returned with <[Min_QTY] in the
criteria for QTY_on_Hand. I have a record in there with
a QTY_on_Hand of 1 and a Min_QTY of 2. This should
return this record but it is not showing any. Any
suggestions?

Thanks a lot.

James
 
Back
Top