If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Fields that don't satisfy criteria
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! |
Thread Tools | |
Display Modes | |
|
|