can't see what the missing syntax is

[Nina Tryggvason]

I'm doing the QBF and trying to program the form's pick list to select records based on the city (Site Code)

the code is:


SELECT AIMS.[HQ Doc #], AIMS.[Regional Doc #], AIMS.[Site Codes], AIMS.[Reg File #], AIMS.[Customer Legal Name], AIMS.Lease, AIMS.[Document Type], AIMS.[Purpose/Use], AIMS.[Effective Date], AIMS.[Termination Date], AIMS.[Next BF Date], AIMS.[BF Reason]
FROM AIMS
WHERE (((AIMS.Site Codes)=[Forms]![bysitequeries]![cboSite Codes]));



and it's telling me that there's a missing operator in the WHERE line

and I am not sure what it is - I copied the code from the example provided in my earlier thread

SELECT Employees.LastName, Employees.FirstName, Employees.Title, Employees.TitleOfCourtesy, Employees.HireDate
FROM Employees
WHERE (((Employees.LastName)=[Forms]![frmMain]![cboPickEmployee]));


I dunno if the fields can't have spaces in the names or if I am being totally dyslextic - but I do not see a difference in the two WHERE lines

 

[boblarson]

AIMS.Site Codes

is missing square brackets because of the space (best to not use spaces or special characters in fields or object names).

AIMS.[Site Codes]

 

[Nina Tryggvason]

thank you

I am getting closer to having this puppy work