Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Prashant kulkarni
  Where is Prashant kulkarni?
 Mumbai
 India
 Prashant kulkarni
 Tags
Subject: Help Required
Thread ID: 311147 Message ID: 311147 # Views: 54 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Wednesday, June 29, 2011 8:18:56 AM         
   


Dear Experts

My Data is As Follows

Table1
---------------
Party_No Eff_DATE Cash Discount
-------- ----------- --------------
BS056 01/04/2009 4
BS056 11/05/2009 4
BS056 21/07/2010 3



Table2

Party_No Invoice No Invoice date Cash Discount
-------- ------------ ----------------- ----------------------
BS056 INV0001 05/04/2009
BS056 INV0002 01/09/2010


Now what i require is Invoice date of Table2 to be searched in between the eff date of Table 1 and cash discount should be updated in table 2


Expected Result

Party_No Invoice No Invoice date Cash Discount
-------- ------------ ----------------- ----------------------
BS056 INV0001 05/04/2009 4
BS056 INV0002 01/09/2010 3


Thanks in advance

ENTIRE THREAD

Help Required Posted by Prashant kulkarni @ 6/29/2011 8:18:56 AM
RE: Help Required Posted by Cetin Basoz @ 6/29/2011 12:08:36 PM