OR and LIKE when searching with a keyword

[jarvjarv]

Hello Access Fans!

I've got this query whereby i would like to find the address information about people by a keyword search on either their name or their quickname which currently looks like this:

SELECT Tbl_Addresses.*
FROM Tbl_Addresses
WHERE ((((Tbl_Addresses.Name)OR(Tbl_Addresses.Quickname)) Like "*" & [Enter a Name] & "*"));

However this doesn't return any results? it works if i search for just the Tbl_addresses.Name or the Tbl_Addresses.Quickname but not for both? does anyone know how to fix this problem?

Thank you

Jarv

 

[RuralGuy]

SQL is a little more literal than that, try:
WHERE (((Tbl_Addresses.Name) Like "*" & [Enter a Name] & "*" _
Or ((Tbl_Addresses.Quickname) Like "*" & [Enter a Name] & "*"));

By the way, Name is a reserved word and a poor choice for a field name.
List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases

 

[jarvjarv]

That did the trick!

Thanks, i've changed the Name as well so hopefully it should go smoothly from now on!!!

 

[RuralGuy]

Excellent! Glad I could help.