Copy data down to next record

[merlin666]

I have a table that gets updated from a query. Some of our date is set to " No Change ". I'd like to be able to copy the last value that isn't equal to " No Change " to the next record until another unique value is found.

For example.

Date - Event - Next Event - Change
2/1 - Concert - Dance - Dance
2/2 - Concert - Concert - " No Change "
2/3 - Film - Band - Band
2/4 - Musical - Musical - " No Change "
2/5 - Film - Film - " No change "
2/6 - concert - musical - Musical

So essentially I would like to update the Change field so that "Dance" gets carried down and overwrites " No Change " until "Band" is found. Then "Band" get carried down etc..

 

[ajetrumpet]

i think you need to restructure your data. it is too much a pain in the butt to query access data vertically. try to make another table and get a relationship in there so you can do manipulation like this in a horizontal manner, like it's programmed for.

and i think i've seen too many of these types of threads where people are trying to "excelurize" an access database and they can't figure out why there is no solution to their problem. i may just write a short FAQ for all of these people explaining why you can't be trying to do this!