Basically I’ve got a query that returns the values of anyone who has tested greater than the value of a combo box. For this I use:
>([Forms]![Rpt_Form]![Score Type 1]-0.01)
>([Forms]![Rpt_Form]![Score Type 2]-0.01)
Each employee has the option of two test types. So I’ve got 2 of the above statements for each of the score types.
The problem is if a user selects the a value out of the Score Type 1 drop down but doesn’t select a value from the Score Type 2 drop down nothing will be returned. I need to write some sort of blanket statement that will return all values unless otherwise noted.
Any suggestions?
>([Forms]![Rpt_Form]![Score Type 1]-0.01)
>([Forms]![Rpt_Form]![Score Type 2]-0.01)
Each employee has the option of two test types. So I’ve got 2 of the above statements for each of the score types.
The problem is if a user selects the a value out of the Score Type 1 drop down but doesn’t select a value from the Score Type 2 drop down nothing will be returned. I need to write some sort of blanket statement that will return all values unless otherwise noted.
Any suggestions?