Expression to Conditionally Omit Info

[nikik]

How would I phrase an expression in a query asking it not to include info in a certain record if there is other info in the first record?

For instance, if a record shows 1 or greater in a field, I don't need to have the info added in for field 2. If it shows <1, I would need field 2 added in for the total to equal at least 1.

=if[column1!Status]=> 1, then leave column 2 blank????

Thanks!
<!-- / message -->

<!-- controls -->

 

[jackd]

You might want to do some research on subqueries where you could read one record, and then get a value from (read) a different record.
There are samples of subqueries here.
http://allenbrowne.com/subquery-01.html or
http://allenbrowne.com/subquery-02.html