Over Production orders on a query

[Dennis Villareal]

we have a system that if a customer asks for 40000 lbs of material and we
produce 41000 lbs for them once the 40000 is shipped to them the 1000 will
not show up on our reports. i would like to make a query where is will show
me if the weight produced is over the weight ordered. both fields are being
pulled in my query now. they are number fields in the table that cannot be
modified.

ORD_BAL_WGT - total ordered weight
RES_RES_WGT - actual weight on order

is there something that i can do where a query will show me all orders with
the "RES_RES_WGT" is greater then the "ORD_BAL_WGT"?

 

[bhicks11 via AccessMonster.com]

Just add "> table.ord_bal_wgt" in the criteria for res_res_wgt in your query.


(Replace table with the name of your table.) Should work if they are both
number type fields.

Bonnie
http://www.dataplus-svc.com

 

[Dennis Villareal]

THANKS!!!

helped alot.

Just add "> table.ord_bal_wgt" in the criteria for res_res_wgt in your query.


(Replace table with the name of your table.) Should work if they are both
number type fields.

Bonnie
http://www.dataplus-svc.com