Update from left in Access 2010

[nixonk]

Hi,

I have a dataset in Access 2010, listing Customer ID's, and a value per Month. I want to be able to update the dataset to carry forward the value from the previous month if there is a blank, i.e. Customer ID 103 value for Feb 15 would be updated to 45.

Customer ID</SPAN>	Jan-15</SPAN>	Feb-15</SPAN>	Mar-15</SPAN>
101</SPAN>	25</SPAN>	40</SPAN>	52</SPAN>
102</SPAN>	35</SPAN>	30</SPAN>	68</SPAN>
103</SPAN>	45</SPAN>		75</SPAN>
104</SPAN>	55</SPAN>	50</SPAN>	42</SPAN>
105</SPAN>	65</SPAN>	70</SPAN>	35</SPAN>

<TBODY>
</TBODY>

 

[krausr79]

Try going to the query creator and making an update query that updates the value of Feb-15 to Jan-15 if it is null. If you only have a few months, make more columns like that. If you have many date columns, try going to SQL view after making one update column. You may be able to copy out the SQL to excel along with column names, and mass-create the rest of the update query.

When doing experimental updates, make a backup of the table first!