Thread: Syntax error
View Single Post
  #1  
Old April 27th, 2004, 02:54 AM
GitarJake
external usenet poster
 
Posts: n/a
Default Syntax error

Can someone tell me what's wrong with this statement? I keep getting a
syntax error when I try to add a combo box to this form.

SELECT DISTINCTROW Contacts.UNIQUE_ID, Users.Name AS NovoName,
Contacts.Company, Contacts.Contact, Contacts.IDStatus, Contacts.[Create
Timestamp] AS CreateDate, Contacts.Phone, Contacts.[Web Site],
Contacts.Industry, Contacts.[Address 1], Contacts.City, Contacts.State,
Contacts.Zip, Contacts.Country
FROM (Contacts INNER JOIN Sales ON Contacts.UNIQUE_ID = Sales.Contact) INNER
JOIN Users ON Sales.[Record Manager] = Users.UNIQUE_ID
WHERE (((Contacts.IDStatus) Like "*customer*"))
ORDER BY Contacts.Company;

Thanks,

Jake