Date Stamps for Values in a Query

[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!

 

[NervousFred]

It is a table from a Query that is pulling data from a linked table. do not
think I have a primary key. I am querying the data from three different
linked tables that are joined together using 3 different fields.

I need the datestamp in the table created by the query.

 

[NervousFred]

Database- Linked, it is linked to another companys DBase Files

Citiation Ultra Query - Select