add values together from different tables

[gungfukid]

I would like to add together integer values from a number of different tables and display the result in a text box. The problem that I am having is that I would like to add only the values that correspond to the selected record (selected with primary key) not the whole table. How do I write this in SQL?
Thanks!

 

[JoeMiller]

You can use the DLookup function to go to foreign tables, find a value and extract it for use in your calculation. If you need to go to one table and get a couple different records summed and return the result you can use the DSum function. Both functions are used similarly and go something like this:

MyResult = DLookup("[MyFieldName]","MyTableName","[MyID]=[MyID]&quot

Now to add a couple different ones just string them together like so:

MyResult = (DLookup("[MyFieldName]","MyTableName","[MyID]=[MyID]&quot) + (DLookup("[MyFieldName]","MyOtherTableName","[MyID]=[MyID]&quot)

HTH Joe Miller
joe.miller@flotech.net