help need to find

[Guest]

in my table i have column named pno(Text)

i have values like "ER,Jan[76J]/07k"

"ER,Jan[77J]/07k"
if i make find by using Ctrl+F (for the above value)

it says no records found...but actually it is there.
please help me.

Thanks

 

[Allen Browne]

Omit the word Like, and it should find it.

Values inside square brackets have special meaning with the Like Operator.

 

[Guest]

The Find will have a problem with this charecters [ ], But yo can use it in a
query

Select * From TableName Where FieldName = "ER,Jan[76J]/07k"

Or
Select * From TableName Where FieldName = [Please enter string]

You'll be prompt to enter a string, writing the text "ER,Jan[76J]/07k" will
return the desired records