Fields that don't satisfy criteria

Hi,

How do data for certain fields appeared only when it meets the criteria set?

My report has 5 fields, say A, B, C, D and E. I've set a criteria for a
hidden field ZZ in the query: Like "*property*"

Currently, those records with any of the 5 fields that met the criteria
appear in the report. If only A and D of Record (1) satisfy the criteria set,
how do I make the data in B, C and E not appeared? Similarly, if only B and E
of Record (2) meet the criteria, data for A, C and D should not appear in the
same report.

Any advice is appreciated. Thanks!

Queries don't normally work like that. They either display values in a column
or don't. You would need code or expressions in your report if you wanted to
selectively hide or disply a text box.

Your request suggests an un-normalized table structure but I could be wrong.
Perhaps if you showed us some actual records and how you would like to see
them in a report, someone could provide a solution.

--
Duane Hookom
Microsoft Access MVP


"tamashii" wrote:

Hi,

How do data for certain fields appeared only when it meets the criteria set?

My report has 5 fields, say A, B, C, D and E. I've set a criteria for a
hidden field ZZ in the query: Like "*property*"

Currently, those records with any of the 5 fields that met the criteria
appear in the report. If only A and D of Record (1) satisfy the criteria set,
how do I make the data in B, C and E not appeared? Similarly, if only B and E
of Record (2) meet the criteria, data for A, C and D should not appear in the
same report.

Any advice is appreciated. Thanks!