I need to update a table: tblImportToAccess.[TradeNo
] and tblImportToAccess.[CoName]
with the value that is in the row above it.
In the pic above, I need the nulls on [TradeNo] and [CoName] to populate with 123 and XYZ respectively for the first null but the second null I would need it to populate with 333 and ABC respectively (much like dragging down the cell above if it were in excel).
My dataset is much larger and there are different TradeNo and CoName.
I am not sure if this would best be done by way of an update query but if so then I have a part of it below and looking for the remainder.
I am a novice user of Access. I can easily do this in excel with a macro but I want to to perform this in access after I import the excel data.
UPDATE tblImportToAccess SET
eNo]) Is Null) AND ((tblImportToAccess.[CoNam
e]) Is Null));