Avatar of darls15

asked on 

Filter records in a forms where one or more fields are blank

Hi Experts

I have a table [tblRegistration] which is imported into my MSAccess database from a system which has no mandatory controls. This table will be continually added to as the data is regularly exported.

To assist in cleaning up the data, I've built a form, [frmRegistration], based on the this table and it includes 7 text fields which need to be checked to ensure data exists in all fields for every record.

I need to filter the recordset to only show only those records containing any blank fields. The fields are named Response1, Response2 ... and so on.

Ultimately, I would like to filter these records using a toggle button on the form so that I can turn the filter on and off again when required.

Would anyone be able to help me accomplish this? I have searched and haven't been able to find anything that works the way I need it to.

Microsoft Access

Avatar of undefined
Last Comment
Jonathan Kelly

8/22/2022 - Mon