Access Expressions

Topic

New Reply

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…

Reply | Quote

Replies

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.

Reply | Quote

Thank you Thomas—Will give this a try.

Reply | Quote