Query By Form Parameter Rejected

[Robot2016]

I have an Access 2016 database containing names, email addresses and dates of hirers together with how many adults and children there were in the party (0-99). I use a form to enable the user to search by different criteria. All works well with the exception of the criteria for "Children" or "No Children". The field concerned holds a number value equating to the number of children in the party. The form has a combo box posing the question "With Children? Yes or No". If the User clicks "No", I put a "0" in an unbound control on the form. If the user click "Yes", I put ">0" in the unbound control. The form passes it's data to a Query which works fine when "No" has been selected but returns no records when "Yes" has been selected. I have tried formatting the field to Number and to Text but it makes no difference. Can anyone help?
Thank you.

 

[Joe4]

The calculation is exactly the same logic and it works perfectly. The original problem with the form looks like an inability to pass the symbols "<>" to the query.

Yeah, I figured that might be the case, but just wanted to see how exactly you were using it/referencing it in your query. Personally, I never use the "Query By Form" option myself, I find it too restrictive. For simple tasks, I may use a Parameter Query, but more times than not, I will have a Form with all my selection criteria, and then use VBA behind the scenes to dynamically write the SQL code I need for my query.