Build query for back order

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

Guest

Hello, I am working with Access 2003. I have a form with field indicating
Stock Number, Qty Order, and Qty Issue. Also included are a text box with
the control source set to =[Qty order]-[Qty Issue], the text box name is Qty
Back Order. A Check box is also on the form that populated with a check mark
if a back order is recognize. What I would like to accomplish is to build a
query that will provide a report of any available back orders.
 
A method I use to get the require result is to build the query with the
required field, then create an query expression as Qty Back Order: [Qty
Order]-[Qty Issue]. Function greater than zero in the criteria field produce
the result.
 
Back
Top