Criteria to show field value based on another fields value.

[Stephenson]

Hello all.



I'm trying to build a criteria for a report. I'm looking for a way to write an expression that will show the value of one field, VendorName if field, RockProduct is not null. I would like to do a similar criteria for Materials, Permits and OutsideServices within the same query. I have not seen how to set the "value" in a query based on anything other than a table, so this is all new to me.

Please let me know if there is a way to write this.

Thank you for taking a look.

[Gina Maylone]

Would you mind uploading your database so I can have a look?

[Stephenson]

Gina, Thank you for taking a look. I have decided to go another route using unbound textboxes with expressions.