Query doesnt work

[drag1c]

Hi,

what could be a reason for this query to not work in microsoft access?

SELECT Max(ZWMTO_Out.Date_Time) AS MaxDateTime, ZWMTO_Out.Project INTO TempTable1 FROM ZWMTO_Out
WHERE
WEEKDAY(ZWMTO_Out.Date_Time) = 4
AND
TimeValue(ZWMTO_Out.Date_Time) < #11am#
GROUP BY ZWMTO_Out.[Project];

It seems pretty simple for me.
Could anyone please check and, if possible, write how it should be?

Error is: Data type mismatch in criteria expression.

 

[drag1c]

Completed with this:

SELECT Max(ZWMTO_Out.Date_Time) AS MaxDateTime, ZWMTO_Out.Project INTO TempTable1
FROM ZWMTO_Out
WHERE Weekday([ZWMTO_Out].[Date_Time])=5 AND Format(ZWMTO_Out.Date_Time,"Short Time")<#11am#
GROUP BY ZWMTO_Out.Project;

You can lock... I hope it can help if needed.