I am trying to use a form field as a parameter to run a select query to be used to generate a specific report. I'm having trouble with the proper SQL syntax. Can anyone please help? If I leave out the WHERE statement it returns all records, but I would like only the records under 1 specific Supervisor.
This is the SQL I tried but returned no results.
SELECT [2008_12_Lawson].Supervisor, [2008_12_Lawson].LastName, [2008_12_Lawson].FirstName, [2008_12_Actuate].ActuateRole, [2008_12_BusObj].BusinessObj_Group
FROM (2008_12_Lawson INNER JOIN 2008_12_BusObj ON [2008_12_Lawson].EEID = [2008_12_BusObj].EEID) INNER JOIN 2008_12_Actuate ON [2008_12_Lawson].EEID = [2008_12_Actuate].EEID
WHERE ((([2008_12_Lawson].Supervisor)=[Forms]![2008_12_Lawson]![Supervisor]));
This is the SQL I tried but returned no results.
SELECT [2008_12_Lawson].Supervisor, [2008_12_Lawson].LastName, [2008_12_Lawson].FirstName, [2008_12_Actuate].ActuateRole, [2008_12_BusObj].BusinessObj_Group
FROM (2008_12_Lawson INNER JOIN 2008_12_BusObj ON [2008_12_Lawson].EEID = [2008_12_BusObj].EEID) INNER JOIN 2008_12_Actuate ON [2008_12_Lawson].EEID = [2008_12_Actuate].EEID
WHERE ((([2008_12_Lawson].Supervisor)=[Forms]![2008_12_Lawson]![Supervisor]));
