Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Unanswered: calculation with field from other table

    Me.iva = (Me.min_amount + Me.comm) * tbl_iva.iva

  2. #2
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Re: calculation with field from other table

    Originally posted by kedaniel
    Me.iva = (Me.min_amount + Me.comm) * tbl_iva.iva
    Ajaj, I hit the Enter key without having plaed the cursor in this text area, hence the posting was sent...

    I receive an error stating that I need to declare tbl_iva as a variable when trying to use the (only) value in that table in a calculation like the above mentioned. Is there a simple way to refer to the first/only value in another table from a control event on a form?

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: calculation with field from other table

    Originally posted by kedaniel
    Ajaj, I hit the Enter key without having plaed the cursor in this text area, hence the posting was sent...

    I receive an error stating that I need to declare tbl_iva as a variable when trying to use the (only) value in that table in a calculation like the above mentioned. Is there a simple way to refer to the first/only value in another table from a control event on a form?
    Try to use

    Me.iva = (Me.min_amount + Me.comm) * [tbl_iva]![iva]

Posting Permissions

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