Hi all,
I have a problem which I can't get my head around.
I have a form which has 5 check boxes on it.
cbxNetwork
cbxSystemOperation
cbxCommercial
cbxEngineering
cbxBusinessResources
The check boxes are not currently bound to the underlying table/query.
I have a table with other fields but also containing 5 corresponding fields (Network;SystemOperation;Commercial;Engineering;BusinessResources) with a data type Yes/No.
What I want to do is to create a query which outputs everything if none of the forms check boxes are touched, and produce a selection if one or more of the forms check boxes are checked.
i.e nothing checked = all results
Scenario : chxNetwork selected, only records with Network checked returned
Scenario : chxNetwork and chxCommercial checked on form, records output which have Network only checked, Commercial only checked and Network & Commercial checked.
etc.. up to 5 check boxes checked.
I have been trying to use the nz() function but cannot produce the correct result.
Thanks
ChrisJF
"He who is not aware of his ignorance will be only misled by his knowledge." - Richard Whatley
I have a problem which I can't get my head around.
I have a form which has 5 check boxes on it.
cbxNetwork
cbxSystemOperation
cbxCommercial
cbxEngineering
cbxBusinessResources
The check boxes are not currently bound to the underlying table/query.
I have a table with other fields but also containing 5 corresponding fields (Network;SystemOperation;Commercial;Engineering;BusinessResources) with a data type Yes/No.
What I want to do is to create a query which outputs everything if none of the forms check boxes are touched, and produce a selection if one or more of the forms check boxes are checked.
i.e nothing checked = all results
Scenario : chxNetwork selected, only records with Network checked returned
Scenario : chxNetwork and chxCommercial checked on form, records output which have Network only checked, Commercial only checked and Network & Commercial checked.
etc.. up to 5 check boxes checked.
I have been trying to use the nz() function but cannot produce the correct result.
Thanks
ChrisJF
"He who is not aware of his ignorance will be only misled by his knowledge." - Richard Whatley