Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007

    Unanswered: How to compare two fields?


    I need some help in writing code which compares total value with four different values and assigns the result to a new field.

    I have the following fields in the form.

    Table name: Sales
    Fields : Totalsalesvalue, price1, price2, price3, price4, indicatedrange.

    Totalsalesvalue is compared with price1, price2, price3, price4 and result is stored in 'indicatedrange' field.
    The values to the 'field indiatedrange' should be upper1/3, middle1/3 and lower1/3. This filed is auto calculate based on 'Totalsalesvalue' field.

    This process should take place before I add a record to the table. I guess the code should be in the form current.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Is there are a reason you're denormalizing your data?

    Maybe you should be using excel.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jan 2007
    I didn't create the database. Somebody else created the database and I am not sure why the table is not normalized. I guess I won't be able to change the table structure. Do you have any suggestions how to go about it with out normalization.


Posting Permissions

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