N
NervousFred
I have a database that has several price values lets say in the first column.
If possible, i would like to have a new column next to the orignal column
that puts in a date of when each specific value was updated but keeping the
dates for the rest of the values the same.
And example would be if we had 3 numbers in a column all updated on 7/1/08
and then when the query updates, the second value changes and so the dates
would then be
7/1/08
8/2/08
7/1/08
Let me know if I need more clearifying.
Thanks!
If possible, i would like to have a new column next to the orignal column
that puts in a date of when each specific value was updated but keeping the
dates for the rest of the values the same.
And example would be if we had 3 numbers in a column all updated on 7/1/08
and then when the query updates, the second value changes and so the dates
would then be
7/1/08
8/2/08
7/1/08
Let me know if I need more clearifying.
Thanks!