How do I use a subquery inside of an update query?

[Gerry Goldberg]

I want to update the amount field in a master table from detail records that I want to sum using a subquery. I think this should be straightforward . Can you give me the proper syntax for this operation?

Thanks,

Gerry Goldberg

[yarbrough40]

I'm not following... please exlain with some detail