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