Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Expressions

    How do you write an expression to calculate from two different tables? I have an obligation total in one table and expenses, vouchers and de-obligations in another table that need to be subtracted. Any ideas...

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Expressions

    There are a few ways to do this, but without additional information ... if you link the tables in a query, then all the fields in both tables will be available for calculations. You can either create those calculations in the query or objects based upon that query.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Idaho, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access Expressions

    Thank you Thomas---Will give this a try.

Posting Permissions

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