I have a form which opens in datasheet view. The record source is a query with two tables joined. The SQL for the query is:
SELECT Activities.Day, Projects.[Project name], Projects.Client, Activities.Hours, Activities.Activity, Activities.Employee
FROM Projects INNER JOIN Activities ON Projects.[Project ID] = Activities.[Project ID]
WHERE (((Activities.Day) Is Not Null))
ORDER BY Activities.Day, Projects.[Project name];
When I just open the query and click on the little down arrow next to the field header named Project name I get an error:
"Syntax error (missing operator) in query expression 'Project name'.