G
Guest
I changed the following criteria in a query from
Like [Forms]![main]![Text45] & "*"
to
Like "*" & [Forms]![main]![Text45] & "*"
in order to search in the middle , end or part of the field.
but somehow the new criteria doesnt work.
any help appreciated...
Like [Forms]![main]![Text45] & "*"
to
Like "*" & [Forms]![main]![Text45] & "*"
in order to search in the middle , end or part of the field.
but somehow the new criteria doesnt work.
any help appreciated...