Maths functions in Tables

[yeomans]

Is it possible to add 2 fields in a table and input the result to a third field in the table. If I can't do this in access tables is there a way around it?

 

[Athiappan]

You can do this with query. Make a calculated field (Example: "Expr1:Field1*field2). Enter the data in the 2 fields and you will get the result in third field.
Is it this you want?

 

[jebry]

Hi!

I don't think you can program a table to do that automatically, but you can do it in a form. It isn't recommended because storing calculated data is not good Db design. Just do the calculations in the report/form/query as you need it.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[yeomans]

I did this in a query. And used a sub form to show the results on my main form. How do I get the results from my sub form to variables in a module so as I can Insert the variables to bookmarks in word

 

[Rolliee]

If you did it in a query, the value is in the query. If you have trouble finding the name ACCESS gives to it, do a debug run and then refer to it as me.fields(?) where ? is the field you found by

for i = 0 to 20
msgbox str(i) & rs.fields(i)
next

rs is the resulting recordset of the query. Capish????

Rollie@bwsys.net