Wildcard Question

[Wrecker]

I need to return data from a field called "cerp" in a query. I entered 888 in the field. In the Critria of the "Cerp" Field I entered: Like "*" & [Cerp?] & "*"

The data will only return properly if I type exactly 888 .I need it to return Data if it finds 888 anywhere in the data.

Example 1555 888 32 03

Thanks
Wrecker

 

[Spellman]

Try using the "%888%" as your wildcard and see if that works. Mark

The key to immortality is to make a big impression in this life!!