Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2007
    Posts
    4

    Unanswered: Table - Default Value

    Hey,

    Ive got a table set up which is not calculating properly (or least i cant seem to get it to) Basically i have a row for quantity and a row for unit price. What i want to do in my table if possible is times the unit price by the quantity so it will come up in my reports which at the moment it isnt doing, as the default value is 0 in my table!
    Might anyone be able to help me on this matter?

    Thanx in advance

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why are you storing this in your tables when you could quite easily calculate it "on the fly" on your report?

    Stick a new unbound textbox on your report and type something like this into it
    Code:
    Qty * Price
    Nice and simple - job's a good'un!
    George
    Home | Blog

  3. #3
    Join Date
    May 2005
    Posts
    1,191
    Agreed with George, you may want to check out the Fundamentals of Relational Database Design, specifically the Third Normal Form section (about half way down).
    Me.Geek = True

Posting Permissions

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