help on sql syntax

[Stylez]

Hi to all.

i am currently inserting and running a script namely:

update tbl_people_directory set = SELECT (FirstName+'.'+MI+LastName+'@accenture.com') AS email
FROM qry_missing_Peoples
WHERE (((qry_missing_Peoples.Email)=' '));

but the system told me that it encountered a syntax error.

hope you could help me on this one and how could i script it using a docmd.runsql command in MS access VBA

Thank you and God Bless