Can you get the result of an IIf statement in a form, to a table

S

Stuart 101

I have written a conditional expression in a form based on an IIf statement.
How do I now transfer the result of this back into the main data table, so
that I can then run queries on the result of this IIf statement ?
 
R

Rick B

Typically you would not do so. Just use the statement in your queries.

Since your statement returns a response based on other data in your table,
it would be redundant to store it. What if the underlying field is
changed - what would cause the resulting field to change?

Post back with details if you still think this is needed. Typically, I
would expect you would not want to store the data.
 
Top