Access Query, Checkbox returns all results that are not empty

I have multiple fields in a table [Table1] that some have numbers in them

I have a form [SearchF] made to run a query that has multiple checkboxes named [field1CHK], [field2CHK] and so on.

When i check [Field1CHK]i would like all records in [Field1] with anything in that field to show up in the query.

additionally if [field2CHK] i would like all records in [Field2] with anything in that field to show up in the query.

and finally if either are checked then to run the query and return if either have anything in them.

......Damn this stuff is hard to explain.

You need to construct your query as a string, adding bits depending on the results of the checkboxes eg

Please Login or Register  to view this content.

Apologies, ive not got Access in front of me but basically create the full query, get the SQL and then break it down into the above sort of construction.