Table A is related to Table B with a unique serial #
Table B has a field "DateCancelled" that is populated with a date if the account is cancelled.
Layout based on table A.
I would like to omit records from the report based on Table A if the date in Table B contains a date.
How do I do that?