Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data integrity (Access 97 / Win.98)

    O.K. I'm stuck again!! Is there a way for me to update a price in a product table and not lose the history of the old pricing? Please keep in mind that I am very new to access, so I would need help in the simplest language possible. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data integrity (Access 97 / Win.98)

    The very simple solution to your problem would be to create a PreviousPrice field (and may be even a DateChanged field) in your products table and copy the price on every change.
    A more advanced solution could be to create and maintain a separate ProductPriceHistory table.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: data integrity (Access 97 / Win.98)

    You wrote:
    >>Is there a way for me to update a price in a product table and not lose the history of the old pricing? Please keep in mind that I am very new to access, so I would need help in the simplest language possible. <<

    This depends on what you mean by "the history of the old pricing". I'm assuming you mean the price at which you sold something for awhile ago. The best way to do this is to include a Price field in your sales record, which is the Product price at the time you sold it. When you create new sales records, you get this Price from the current value of the PRice in the Product record.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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