I got what I needed by doing a sql query instead. It was too difficult to try to do it in a BAQ even though it probably could have been done. Ran the sql query below to find how many parts have anything entered in the Urgent Planning fields.
select * from PatchFld where PatchFld.tablename = ‘partplant’