Database Discussion - auto fill up data in MS Access

Print Page | Close Window

auto fill up data in MS Access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15233
Printed Date: 29 March 2026 at 7:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: auto fill up data in MS Access

Posted By: tmwong
Subject: auto fill up data in MS Access
Date Posted: 26 May 2005 at 9:40am

how to make the data in certain column to be auto filled into the next row of the other column? for example, i have two fields: "Present value" and "Previous Value". The value of "Present value" of this month should be the "Previous Value" of next month. so, how to make the record from "Present Value" to be auto filled into the next record of "Previous Value"?

-------------
I learnt from the hardships.

Replies:

Posted By: dj air
Date Posted: 26 May 2005 at 9:53am

do a
strSQL = "UPDATE table SET table.Previous_Value = table.PresentValue WHERE table.ID = value"

the above will update a table so previous_Value is updated to the Present_value where the table.ID = Value.

thatsd just an example SQL