Expression to conditionally omit info

[Niki]

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!

[NTC]

you ask about a query, but users don't enter data into queries; are you working at the form level?

calculated fields are straightforward at the query level. you want to research the iif method (there is no 'if' in queries).....

but if this does involve user input - then your calculation can occur at the form level rather than the query (record source level) ....

[Niki]

I'm querying my table and would like it to return a value only if the same value does not exist in another field. So, the iif seems to be it, but I can't figure out what it needs to say exactly.

[Niki]

Here is my zipped DB. In the query WIP, I'd like to create the criteria that basically says:

If a protein is selected in qryProtein whose Grain >1, no qryGrain.

I'd like to create that same expression for other items who have more than one meal component.

Help - please & thank you!