У меня проблема, когда я использую NOT LIKE
. Насколько мне известно, это правильный синтаксис, однако запрос по-прежнему возвращает запись, где [H1 Full Name] = SPEC
. Любые идеи, почему это так?
SELECT [Unit Owner Listing].[Unit#],
[Unit Owner Listing].[Combined Name],
[Unit Owner Listing].Address,
[Unit Owner Listing].[Home Phone],
[Unit Owner Listing].[H1 Cell Phone],
[Unit Owner Listing].[H1 E-Mail],
[Unit Owner Listing].[H2 Cell Phone],
[Unit Owner Listing].[H2 E-Mail],
[Unit Owner Listing].[H1 Last Name] & ', ' & [Unit Owner Listing].[H1 First Name] AS [H1 Full Name],
IIF([Unit Owner Listing].[H2 Last Name] IS NOT NULL,
[Unit Owner Listing].[H2 Last Name] & ', ' & [Unit Owner Listing].[H2 First Name],
NULL) AS [H2 Full Name]
FROM [Unit Owner Listing]
WHERE (
(([Unit Owner Listing].[H1 Last Name])<>"")
OR
(([Unit Owner Listing].[H1 Last Name]) Not Like "*SPEC*")
OR
(([Unit Owner Listing].[H1 Last Name]) Not Like "*MODEL*")
)
ORDER BY [Unit Owner Listing].[H1 Last Name];