use in statement in access query
Posted on 2016-09-02
I am trying to run an Access query by using value from a text box from a form as a parameter
in the query i have an employee field and I am putting my parameter as
[Forms]![frm_test]![Text4] and it does not return anything. text in text4 is
in ( "Brian Sasso","Robert Sayour","Michael Cuccia",)
If i copy and paste the value from textbox into the query it runs ok and returns everything like how i want it to be.
what am i doing wrong. why isn't the query reading value from the text box
also i have tried putting this in the parameter
in ([Forms]![frm_test]![Text4] )
and in that case value of my textbox is
"Brian Sasso","Robert Sayour","Michael Cuccia"
still it does not return anything. p
can someone please let me know what am I missing