Question Add a static value to a column in Access 2003

[Jamie]

I'm trying to modify an Access db created by a former employee. He used to type in the mthly hours worked to calculate monthly utilization. The rest of the data for utilization was imported from an Excel file, and Hrs Worked is a column added to that table. I want to add that Hrs Worked value automatically rather than type in the value for 10,000+ rows. I'm not good with sql yet. There is a column labelled 'Hrs Worked' that is blank until someone types in '168' all the way down and runs the entire macro.
Is there a way to populate that entire column without manual work?

 

[MStef]

Try to do it via UPDATE QUERY.
Before, take a copy of this table.