Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Merge - 18 Mar 2007 19:51 GMT

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

Reply to this Message

John W. Vinson - 18 Mar 2007 20:47 GMT

>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

In a query.

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

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]

Reply to this Message