Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    7

    Unanswered: access query, with multiple tables

    i have a query to make a form using bits from lots of tables.
    well 3 tables. it is to show a savigns orderfor a custoemr saving to buy a bike - for an A level project.

    i have Payment_Amount from tblOrder , Price from tblModel
    and a field called Amount_to_Pay

    i want Amount_to_pay to be calculated when an amount is entered into the Payment_Amount field.
    will be Payment_Amount - Price

    where do i put the epxression and what do i write?is it possible to have a calculated filed in a form?

    thanx for all ure help, as u might guess buy user name im not very skilled with access!

  2. #2
    Join Date
    Feb 2005
    Location
    Scotland
    Posts
    1
    As the third entry in your query, put
    Amount_to_pay:[Payment_amount]-Price

    Then you can have Amount_to_pay on your form.

Posting Permissions

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