updating a field

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I have a table which has the field: qtyA, qtyB, orderQty,
qtyMin, orderMinQty
Now for each line, I want:
For orderQty; if(qtyA<=qtyB) then orderQty=qtyA else
orderQty=qtyA-qtyB endif
and
For orderMinQty; if((qtyB-qtyA) < qtyMin) then
orderMinQty=qtyMin else orderMinQty=0 endif

What is the fastest and easiest way to perform this on
each row.
Thanks,
Jim.
 
Jim

Already answered in the 'queries' newsgroup. It's rarely necessary to post
in more than one group. If you must, please select relevant groups in your
'groups field and post once, rather than separate posts to multiple
groups -- it's a courtesy thing. Plus, an answer in any one group shows up
in all you selected.
 
Back
Top