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.