I have a column in my table that contains blank values. Those blank values are related to the record directly above the blank value. I want to be able to use an update query to fill in the blanks. I did this once before, but I can't remember how I did it. I remember it involved creating a function in VB and then calling that function as part of my update query. The function basically stated " set the first record as the one to copy to the next record if the value of the second record is null". It looked for null values and filled in the null field with the field data directly above it. It worked beautifully. Has anyone ever had occasion to use that type of function in conjunction with an update query?