Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

update all records in a database with a specific value for one field

I’ve got to insert a value for every record (currently over 20,000) for a new field in a database table which is essentially a date, and always the same date for every record. I’ve never had to do this before, can anyone share a basic SQL query on how to accomplish such a task, or any way in the Access ‘table tools’ on how to do it in most efficient way? I didn’t know if there were any alternatives to Excel autofill/flash fill where it could be copied down to all records. I would prefer a query solution if possible to get an understanding how do it for future reference. But any features that are equivalents to Excel autofill/flash fill would also be interesting. There is no real update or overwrite to perform in the query, as currently every record in the table has no value entered for this field.

ASKER CERTIFIED SOLUTION
Avatar of _agx_
_agx_
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial