Tables

M

Merge

I need to add a column and create an IIF statement
Can I do this in a table or do I need to do this in a query

The result of the if statement will be a filed that I will need to use as a
replationship

Thanks
 
J

John W. Vinson

I need to add a column and create an IIF statement
Can I do this in a table or do I need to do this in a query
Click to expand...

In a query.
The result of the if statement will be a filed that I will need to use as a
replationship
Click to expand...

You can't do an enforced table relationship on a calculated field, and should
never need to do so; you can join a calculated field in a query if you want...

What is the IIF statement? What field are you starting from, and why do you
feel that you need to calculate a value for a relationship, rather than
relating on the "real" data?

John W. Vinson [MVP]
 
Top