I am trying to retrieve data from a access query based on a value in a combo box. The field I am trying to pull from is a numeric field called "balance". I have three options in my combo box that looks up from a table. They are:
0 Paid in Full
>0 Amount Owed
The combo box has two columns with the first column hidden. My query will only work when I select the "Paid in Full" option. I assume because this is numeric. If I replace the combo box lookup criteria with any of the values above (0, >0 or >=0) the query works fine. I am assuming that the translation for >0 and >=0 just isn't correct when pulling from a combo box.
Is there a way to get the query to understand those values?