I have values in a table that I want to use to calculate other fields in another table.
How can I make an if statement to look at a field in one table and then look at another for a value?
Also, How can I run this function?

[This message has been edited by archiecone (edited 02-21-2001).]

You can use DLookup to get the values in the tables. You can do the calculations on a form or in a query.