Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013
    Posts
    1

    Unanswered: Compair dates to retrive another value

    I have 2 tables - one for Prices (it is historicale) second for Transactions
    transactione tables include fields: products id - date - price
    prices tables iclude: product id - date of change price - price
    my problem is:
    I need to enter date in transactione table - field date then access search for the period of the date that the price changed and put the price from table prices in the table transaction - field price.
    Thank u alot.

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    So you need to walk the transaction table saving the price until either the end of the table or the Date of Price Change > the current date your using, right? Once the limit is reached, you have the price you need, right?
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •