dlookup - single quote in criteria 1

[jibberski]

GRRRR - frustrating error

Using access 2003:

How do you handle a Dlookup with a single quote in the criteria?

ie < O'brien > or < The smiths' >

Nz(DLookup("[TotalSales]", "SalesTeam", "[Name] = '" & StrV & "'"), 0)

Produces
Runtime error 3075: syntax error in string in query expression
'Name='TheSmiths'

 

[PHV]

Nz(DLookup("[TotalSales]", "SalesTeam", [tt]"[Name] = '" & [!]Replace(StrV, "'", "''")[/!] & "'"), 0)[/tt]

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

 

[jibberski]

Nice work - Thanks for the help.