searching for *[Combo8]*

[butthead]

SELECT WeldList.*
FROM WeldList
WHERE (
((WeldList.Date)
Between
[Forms]![Frm WeldList Search]![StartDate]
And
[Forms]![Frm WeldList Search]![EndDate])
and
((WeldList.WS)
=
[Forms]![Frm WeldList Search]![Combo8])
);

the value in combo8 may be d5. I need to search all
WeldList.WS fields for the value of d5. I am missing all
the records that may contain d5/68 or some other combination
that contains the d5 value. where do I put the asterisks
in
[Forms]![Frm WeldList Search]![Combo8]

or is there a contain keyword that I am not finding in
acess 97

any help would be appreciated

tomcruz.net

 

[PHV]

HAve you tried something like this ?
WeldList.WS Like '*' & [Forms]![Frm WeldList Search]![Combo8] & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[butthead]

I can see why you are numero uno on the list.

I do appreciate the tip. it is exactly the solution
I was looking for. it works great.

thanks a million. were do i send the check. ;-)

tomcruz.net