Hi Everyone,
I've been struggling with this for a minute "Lol" . I built this Select-Query that has Six(6) tables and is also the Record-Source for a Report. However I recently added another Table seven(7)tables base on the information my Supervisors want.. good...ok!, Everything again works fine .... BUT If there's no entry into the particular field i.e. the seventh table ...the record will not show up... I want it to filter where isNull and is not Null and the record shows on the report.
Note this expression
Code:
=IIf((IsNull([tblStations]![InTakeStation])) And (IsNull([tblStations]![InTakeStation ])),"","Not Available")
works but still omits the record that has no available data and when I change it to
Code:
=IIf((IsNull([tblStations]![InTakeStation])) And (Is not Null([tblStations]![InTakeStation ])),"","Not Available")
I get syntax error any Help!
This code in criteria [Expression Builder] works but where there's no data in the particular field it does not produce into the report ....even though I want to trap this information also?