Hi All,
I'm trying to pass either Greater than 0 or Less than 0 to a query from a combobox on a form. It does not work because the query is looking for <0 as a value when it should be pulling up all negative numbers. The same is happening with >0.
My combobox has two values the user can select. >0, <0.
Does any one know how to over come this problem? All advice would be much apreciated.
Thanks
Cashe
I'm trying to pass either Greater than 0 or Less than 0 to a query from a combobox on a form. It does not work because the query is looking for <0 as a value when it should be pulling up all negative numbers. The same is happening with >0.
My combobox has two values the user can select. >0, <0.
Does any one know how to over come this problem? All advice would be much apreciated.
Thanks
Cashe