In Excel you can have data in one cell copy to another cell by entering =b1 into the cell you want. (b1 is random, of course). I would like to do something like that in Access. I enter a present day reading and a previous day reading everyday into a log. Today's present reading will be tomorrow's previous day's reading. Instead of entering both everyday, is there a way that my present day will automatically move to previous day's cell for the next day's entries? I hope I made sense with that explanation. If not I can send the table for a visual. Thanks for any help...
