Criteria

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

I have a query that is looking at a text field in a form
but what i need to do is that a user can enter a text in
that field and must list all the records that has that
text, the field i got is a long string and i need text
taht contains the text that was entered in the form.

I have tried using IIF (field not null then field
else "") but this doesnt work or i ma not doing it right.
I have use "Like " txt field but not sure i can do that I
tried using "Like " & form.field but i need to put it in
quotes but it gives me an error.

Can someone give me an idea on how i can do this?

Thanks
Vina
 
Try using the Instr Function...Use it will 2 look thru a
Field 4 a particular string pattern Ex. Instr(1,
[Fieldname],"SearchString",1) if the SearchString is found
in that field -1 wil b returned 4 true. Using this method
in a query that filters 4 only -1 in the Calculated Instr
field will show the desired results...
 
Thank you very much , this works!!!!
-----Original Message-----
Try using the Instr Function...Use it will 2 look thru a
Field 4 a particular string pattern Ex. Instr(1,
[Fieldname],"SearchString",1) if the SearchString is found
in that field -1 wil b returned 4 true. Using this method
in a query that filters 4 only -1 in the Calculated Instr
field will show the desired results...
-----Original Message-----
I have a query that is looking at a text field in a form
but what i need to do is that a user can enter a text in
that field and must list all the records that has that
text, the field i got is a long string and i need text
taht contains the text that was entered in the form.

I have tried using IIF (field not null then field
else "") but this doesnt work or i ma not doing it right.
I have use "Like " txt field but not sure i can do that I
tried using "Like " & form.field but i need to put it in
quotes but it gives me an error.

Can someone give me an idea on how i can do this?

Thanks
Vina
.
.
 
Back
Top