Please help Access Query Unable to open in design view only showing SQL need Help!!!

[sandeebee123]

I am trying to run an Access query that someone completed in SQL. Below is the query:

SELECT Employees.Supervisor, [Work Hours].[Full Name], [Work Hours].[Date Worked], [Work Codes].[Productivity Type], [Work Codes].WorkCode, Sum([Work Hours].Hours) AS Hours, [Work Hours].Description, [Work Hours].ManualCount, [Employees-Active].WindowsID AS SupWinID
FROM (Employees INNER JOIN ([Work Hours] LEFT JOIN [Work Codes] ON [Work Hours].[Work Code]=[Work Codes].ID) ON Employees.[Full Name]=[Work Hours].[Full Name]) INNER JOIN [Employees-Active] ON Employees.Supervisor=[Employees-Active].[Employee Name]
WHERE (((Employees.EmpType)="RS"))
GROUP BY Employees.Supervisor, [Work Hours].[Full Name], [Work Hours].[Date Worked], [Work Codes].[Productivity Type], [Work Codes].WorkCode, [Work Hours].Description, [Work Hours].ManualCount, [Employees-Active].WindowsID


HAVING ((([Work Hours].[Date Worked]) Between (Date()-Weekday(Date()))-6 And Date()-Weekday(Date())))
ORDER BY Employees.Supervisor, [Work Hours].[Full Name], [Work Hours].[Date Worked];

I am getting the following error:
Compile error. in query expression '((([Work.Hours].[Date Worked]) Between (date()-Weekday(Date()))-6 And Date ()-Weekday(Date()))'.

[TG_W]

Make sure all of the tables and fields are still named the same and have the appropriate properties. I would start with [Work Hours].[Date Worked].

[sandeebee123]

I don't know SQL enough to do that.

[TG_W]

In SQL, the brackets hold the names of the tables and fields - [TableName].[FieldName]. Based on that information in the SQL, look at the TABLES in your database to make sure all of the FIELDS are still present. It sounds like a Field or Table has been deleted.

[sandeebee123]

So where do I put that? in the beginning?

SELECT * FROM Users WHERE Clue > 0

[sandeebee123]

So what do I do? I can only view it in SQL.

[TG_W]

You should be able to look through the database to find the tables.

Can you post the database for analysis?

[TG_W]

You can copy the SQL to a Note Pad file, close the query, then look through the database deleting each Table.Field combination you come across as you walk through the SQL.