Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculation Field in a Form (Access 2003)

    I have an order details table that I need to store the quantity * the price. I can get it to show on the form but it is not being stored in the table.
    Thank you in advance

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calculation Field in a Form (Access 2003)

    Hi Robin

    The best thing to do in this case is to create a query from the table which has the field

    OrderAmount: [quantity]*[price]

    and run the form from that query
    Jerry

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation Field in a Form (Access 2003)

    How do I get the OrderAmount stored in my Order Details table.
    Thanks

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calculation Field in a Form (Access 2003)

    You don't need to. The query stores the data and you can report on that.
    Jerry

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculation Field in a Form (Access 2003)

    Jerry is correct: unless there is a very specific reason for it, you shouldn't store calculated information in a table. Tables should be used to store the basic data, and queries can be used to perform calculations based on those data. Storing calculated information takes up unnecessary space, and it might easily get out of date if you don't take care to update it whenever the basic data are modified.

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

    Re: Calculation Field in a Form (Access 2003)

    As others have pointed out, you don't need to nor should you store calculated data in a table. You really should acquaint yourself with the process of "database normalization". This encompasses some rules for the design of databases, with the purpose of ensuring the integrity of the data while maximizing the ability to use the data. Most Access books have at least a chapter devoted to this topic.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculation Field in a Form (Access 2003)

    Thank you all for your help and suggestions. This is a wonderful form and everyone is so helpful.

Posting Permissions

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