ms-access 2007 macro - (RUNSQL)

Hello

I have created a macro in ms-access 2007 to execute the below query, but the error prompts syntax error in query expression.
Kindly help on this sql query, i need to delete the records holds maximum date in the table

delete * FROM EDWShipments where EDWShipments.BRIC_LoadTime in (select max(EDWShipments.BRIC_LoadTime) from EDWShipments

This is not working, can any help on this.

Thanks
jim

If you run it in a new query in access' query designer, what does it highlight or does it run fine? Looks ot be missing a closing parenthesis but not sure itf it was just a copy/paste issue to your post.