select query criteria using like 1

[percles34]

i have a query that searches records by street address. the enter the parameter box sez: "Type the Address." however since new englanders being the most creative spellers in the world spell everything differently and condo numbers, etc are enterered in different styles. so i have tried to use (Or Like "*&quot and various other combonations.

Any ideas

jesse...

 

[SteveR77]

Jesse,


What you want to use is - Like [Address]&"*"


That way if Cam is entered you'll get Camden, Cambridge, etc


HTH,


Steve

 

[threeunderpar]

Hey Jesse.

In your criteria enter something like this
under the address field:

Like "*" & [Type the Address] & "*"

Hope this helps you.