I have a field "VIN" that contains "*&*" and "*" types of data.

say if I do a search for "1GC&G39R" it will show up...great

but if I do a search for "1GC5G39R" it will not find anything.

How can I tell the database to look for both types and just display the relevant variables i.e "1GC&G39R" and not all those records which have an "&" in them. without reinputting the data myself

thanks

You might try making your search field a calc that has both options:

VIN_Search (calculation, text result) = VIN & & Substitute(VIN; "&"; "")

Thanks Ender!

I tried your solution and I can't get it to work probably because I am not inputting it the right way......

I have tried and tried for the last 3 days with this thing and I can't figure it out.

Could someone please help me out I would really appreciate the help

I have uploaded the database here:

http://www.smartdustlab.com/help.zip

You have to hold the shift button when opening

account= admin

pass= help

Create a calculation field with a text result, using Ender's calc: VIN &

I am sorry I don't get it

Just as Queue and Ender has said, create a new calculation field (text) cNewField = VIN &

It doesn't work...............

I created a new field just like you said and it doesn't return results..............

take a look at your file that I modified.

help.zip

THANK YOU THANK YOU!

I see where my error was