A
acccessaccess2003
I have the following query, qryCumulative
Week targetTotal actualTotal
1 3 3
2 5 nothing shown
3 9 4
4 nothing shown 6
An example of the query results that I wish to attain is this:
Week targetTotal actualTotal
1 3 3
2 5 3
3 9 4
4 9 6
I've tried creating an UPDATE query but Access shows me an error message
indicating that 'Operation must use an updateable query.'
The UPDATE query is as follows:
UPDATE qryCumulative SET qryCumulative.[targetTotal] =
DLookUp("[targetTotal)]","qryCumulative","[Week] = [Week]-1"),
qryCumulative.[actualTotal)] =
DLookUp("[actualTotal]","qryCumulative","[Week] = [Week]-1")
WHERE (((qryCumulative.[targetTotal]) Is Null)) OR
(((qryCumulativeTest.[actualTotal]) Is Null));
How can I insert/update the values from the previous row to the null cells
so that I can generate a continuous line chart and not have breaks in between
due to the null values?
Week targetTotal actualTotal
1 3 3
2 5 nothing shown
3 9 4
4 nothing shown 6
An example of the query results that I wish to attain is this:
Week targetTotal actualTotal
1 3 3
2 5 3
3 9 4
4 9 6
I've tried creating an UPDATE query but Access shows me an error message
indicating that 'Operation must use an updateable query.'
The UPDATE query is as follows:
UPDATE qryCumulative SET qryCumulative.[targetTotal] =
DLookUp("[targetTotal)]","qryCumulative","[Week] = [Week]-1"),
qryCumulative.[actualTotal)] =
DLookUp("[actualTotal]","qryCumulative","[Week] = [Week]-1")
WHERE (((qryCumulative.[targetTotal]) Is Null)) OR
(((qryCumulativeTest.[actualTotal]) Is Null));
How can I insert/update the values from the previous row to the null cells
so that I can generate a continuous line chart and not have breaks in between
due to the null values?