Where to implement

[accessjpm]

Could someone explain where to implement this SQL (full explaination would be great since I am pretty clueless on this). Click the link.

http://www.access-programmers.co.uk/forums/showthread.php?t=70751

thanks all

 

[accessjpm]

Wildcard Syntax

So I have the following code in my query:


FIELD: Expr1: [CounterpartyName]=[Forms]![test]![CPNAME] Or [Forms]![test]![CPNAME] Is Null

CRITERIA: True

unfortunately this only returns a record when the name is typed exactly. How can I use a wild card to return records when only part of the name is typed.

i.e. If i type "black" I would like to get back "blackrock, black horse, ba ba black sheep" etc

 

[WayneRyan]

jpm,

FIELD: Expr1: [CounterpartyName] Like "*" & [Forms]![test]![CPNAME] & "*" Or [Forms]![test]![CPNAME] Is Null

Wayne