Copying certain fields from One group of records to another in same table

[JohnnyBGood]

Hi,

I have a single table (it's a BOM Requirement table).

So I have one column (field) of the table labeled BaseID. I have multiple BaseIDs and and they each have multiple Records.

I want to be able to take all the records for a BaseID (say 100 or so) and I want to copy only certain associated fields for that BaseID to another BaseID's 100 or so records.

Is there a way to do this, maybe in an Update Query?

 

[JohnnyBGood]

Any suggestions? Even if you think it doesn't require a query.

Thanks