I have a database that was derived from a report. The data looks something like this:
Obj ObjSource Date Ref# Amt
22122 SOURCE1 9/24/07 DR3245 100.00
10/15/07 CT3199 88.00
12/3/07 DR3210 100.00
22123 SOURCE2 8/15/07 CT3455 50.00
9/15/07 GT3011 200.00
The blank spaces in the OBJ and OBJSOURCE fields should be filled with the OBJ and OBJSOURCE above it, but I can't figure a way to get those fields to auto fill with the information and change appropriately. In Excel, I would copy and paste or autofill - is there a way to do it in Access? If there was a field I could use as a reference I could do it, but there is no correlation between any of the other fields in the table and what has to appear in OBJ and OBJ source. Any suggestions? I am not a Visual Basic person, so it would have to be an update query of some sort or code I can copy and paste after changing the field names.