Thanks to every one for your help, different ways of accomplishing a task helps me greatly to understand how things work.Again thanks
--- In [email protected], "Tom Oakes" <[EMAIL PROTECTED]> wrote: > > Or something like this: > > UPDATE tblTableName SET Status='Over Shipped' WHERE [Ship Qty] > > [MaxShipQty] > UPDATE tblTableName SET Status='Short' WHERE [Ship Qty] < [Order Qty] > UPDATE tblTableName SET Status='Pass' WHERE ([Ship Qty] >= [Order Qty]) AND > ([Ship Qty] <= [MaxShipQty]) > > > Tom Oakes > Personal PC Consultants, Inc. > [EMAIL PROTECTED] > 503.230.0911 (O) > 402.968.6946 (C) > 734.264.0911 (F) > > > _____ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Glenn P MSG > (Ret) FL-ARNG > Sent: Tuesday, November 08, 2005 6:38 AM > To: [email protected] > Subject: RE: [AccessDevelopers] Re: Database for training > > > > Try: > > With rst > .MoveFirst > Do Until .EOF > .Edit > If [Ship Qty] > [MaxShipQty] Then > !Status = "Over Shipped" > ElseIf [Ship Qty] < [Order Qty] Then > !Status = "Short" > Else > !Status = "Pass" > End If > > rst.Update > rst.MoveNext > Loop > > End With > > Set rst = Nothing > Set dbs = Nothing > > Glenn P. Jones > > > > Please zip all files prior to uploading to Files section. > > > > > SPONSORED LINKS > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+developer&w1=Microsoft > +access+developer&w2=Microsoft+access+help&w3=Microsoft+access+traini ng&w4=M > icrosoft+access+training+course&w5=Microsoft+access+programming&w6=Mi crosoft > +access+tutorial&c=6&s=193&.sig=KSo10FhBiVoDJma_MKu8QA> access developer > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+help&w1=Microsoft+acce > ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+training&w4 =Micros > oft+access+training+course&w5=Microsoft+access+programming&w6=Microso ft+acce > ss+tutorial&c=6&s=193&.sig=cr0i-cpNYhQ7i5cl6pc6Ug> access help Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+training&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+trainin g&w4=Mi > crosoft+access+training+course&w5=Microsoft+access+programming&w6=Mic rosoft+ > access+tutorial&c=6&s=193&.sig=h83hAX-ymbiRVl4_jANiNg> access training > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+training+course&w1=Mic > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+ trainin > g&w4=Microsoft+access+training+course&w5=Microsoft+access+programming &w6=Mic > rosoft+access+tutorial&c=6&s=193&.sig=dibC4fB9qwog7DVzytgZhQ> access > training course Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+programming&w1=Microso > ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+trai ning&w4 > =Microsoft+access+training+course&w5=Microsoft+access+programming&w6= Microso > ft+access+tutorial&c=6&s=193&.sig=Y1PziOwalD3wheXhxsSg0w> access programming > Microsoft > <http://groups.yahoo.com/gads? t=ms&k=Microsoft+access+tutorial&w1=Microsoft+ > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+trainin g&w4=Mi > crosoft+access+training+course&w5=Microsoft+access+programming&w6=Mic rosoft+ > access+tutorial&c=6&s=193&.sig=L5JxiKeRY5EEY0DuhGMqqQ> access tutorial > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
