Hi, Hope someone can help me with this. I have a table with data in following format:
250,25
251,25
252,25
253,25
254,25
that I want to add 2 new columns like following
250,25,1,4
251.25,5,4
252.25,9,4
253.25,13,4
254.25,17,4
where the value in the 3rd column is the sum of the values of 3rd and 4th columns in the previous record (except for the 1st record which the value 1 is fixed in the 1st line.
Can I do this with macros? with Jet SQL or I can only write function for this dynamic data update?
thanks..
250,25
251,25
252,25
253,25
254,25
that I want to add 2 new columns like following
250,25,1,4
251.25,5,4
252.25,9,4
253.25,13,4
254.25,17,4
where the value in the 3rd column is the sum of the values of 3rd and 4th columns in the previous record (except for the 1st record which the value 1 is fixed in the 1st line.
Can I do this with macros? with Jet SQL or I can only write function for this dynamic data update?
thanks..