var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
how can i search using LIKE? let's say i have a name MARK,ARK when i type ARK both should be included in the result...
can you teach me how to do a simple search?
Originally Posted by oeuf85
ma* gets Mark but noth Ark
*? find all entries
The above is when using the binoculars to find
But if using for search criteria in a query then it becomes Like "*ark" etc
Last edited by Mike375; 06-19-04 at 10:52.
If your using a query to look at a form set for seaching use this in the criteria
Like [Forms]![NAME_SEARCH]![first_name] & "*"
[Forms]![NAME_SEARCH] = the form name
![first name] = the textbox name for the query criteria to look in
& "*" = and anything remotely like your entry (that will give you the mar ark etc)