I created the report on another computer.
Here is the source of your report
Code:
SELECT tblDiscography.fldDiscNo, tblDiscography.fldDiscTitle, tblDiscography.fldLabel, tblDiscography.fldReference, tblDiscography.fldClass, tblRecordStorageLocations.fldSection, tblRecordStorageLocations.fldLocation,tblRecordStorageLocations.fldSeqSort1_Section FROM tblDiscography LEFT JOIN tblRecordStorageLocations ON tblDiscography.fldLocationID = tblRecordStorageLocations.fldLocationIDWHERE tblDiscography.fldDiscNo>0 AND tblDiscography.fldClass LIKE 'L'
See anything wrong with it?
Section was the name I gave to the IIF expression in the query.
I have had to create a quick report again as I am now on my laptop.
The report section header has the query IIF() on the left and the same IIF() as control source on the right.
You can take it from there.