Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    70

    Unanswered: Calculated Fields across relational tables

    Sorry, I have re-designed my database. Can this thread be closed or deleted please?
    Last edited by kkid; 10-03-12 at 12:34.

  2. #2
    Join Date
    Aug 2012
    Posts
    70
    Blank Post
    Last edited by kkid; 10-03-12 at 12:34.

  3. #3
    Join Date
    Aug 2012
    Posts
    70
    sorry, i've been updating my database and this thread is no longer needed as i have completely changed it.

    Can it be closed/deleted please?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    do the maths as a number, but change the display format in your foprm or report to be currency

    if you are struggling then consider using subqueries to sum the values in the separate table
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Aug 2012
    Posts
    70
    Quote Originally Posted by healdem View Post
    do the maths as a number, but change the display format in your foprm or report to be currency

    if you are struggling then consider using subqueries to sum the values in the separate table
    Thank you for your input, I've actually been changing my database around a bit so I don't actually have these issues any more.

    Sorry for the hassle

Posting Permissions

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