text box filter with <, >, <=, >=

[Benwatson]

hi all im hoping that some one will be able to help me

i have a text box that users will need to put values such as >5 <5 to filter through results

problem is when i put >5 or <5 its not displaying anything

this is the expression im ussing in the Query

Like IIf(IsNull([Forms]![frmareaussererrorcount]![txtnumbererr]),"*",[Forms]![frmareaussererrorcount]![txtnumbererr])

 

[Minty]

That will put the string ">5" into the query. If you do that it would not work. You need to use the Eval() function but it's not super straightforward. Search on here for that function .