I’m trying to generate a report that lists only the entries in a table of music recordings that contain two of the four (CD, LP, OR and SACD) possible values that can be contained in one field (Format) of the table. I tried using a row of IIf statements with one statement for each of the fields I want to print in each detail line of the report. The IIf statement shown below is an example, and prints one of the desired fields for each line of the report. This causes the correct table entries to print (CD and SACD), but it leaves blank lines for all the table entries that contain the other two values that I don’t want to print (OR and LP). How can I print the entries I want without getting all the blank lines?



Detail
=IIf([Format]=”SACD” or [Format]=“CD”,[Album_Title])

By the way, I’m a novice with Access so I can’t do anything complicated without a pretty thorough explanation.

Thanks,
Joe