CODEWITHSUNDEEP
sqlms-access
logicForPresident
logicForPresident

Reputation: 311

Populate column using single cell value from a different column with SQL

I am trying to populate an entire date column in an Access database with a single date value for when the data was collected. The date value is contained in each table, but I want a separate field containing the date in each row. When I used this code it only populated the one row in my new field (sampling_date) where the date is located. The date is located in the sampling_info field on row 4

UPDATE table SET [sampling_date]=[sampling_info] WHERE [point]=4;

Thanks for any help,
Paul

Upvotes: 0

Views: 2162

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123409

It sounds to me like this is what you're after

UPDATE [table] SET sampling_date = DLookup("sampling_info","table","point=4")

Upvotes: 3

Related Questions