A Logic Question

[Guest]

I have a logic question. If I write an expression along the lines of "look
at the value in this table, and based on it, display the value from this
query." Is this possible?

Thanks.

 

[Rick Brandt]

I have a logic question. If I write an expression along the lines of
"look at the value in this table, and based on it, display the value
from this query." Is this possible?

Thanks.

It's a broad question so I will give a broad answer.

Yes.

I would add that the idea of "look at the value in this table" is fairly
nonsensical since a table can contain many columns and many rows thus an
indefinite number of "values". You would need to specify which field in which
record you want to examine. Similarly. "the value from this query" is also too
ambiguous to have any real meaning.

You'll need to define the problem-space a bit more clearly.

 

[Larry Daugherty]

Sure, a simple conditional statement gets it done.