Date Stamps for Values in a Query

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

dustinbrearton via AccessMonster.com

What is your primary key in this table? Is that primary key in the data that
you are updating from? Are you going to update via a linked table or just a
manual input of the new price?
 
N

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.
 
D

dustinbrearton via AccessMonster.com

Can you list your table and query structure as below for me? I am not quite
sure what your current setup is. I believe that you must have an update
query that pulls from one of the linked tables to update another.

TableName - Table Type (Linked/Standard)
QueryName - Query Type (Select/Update/Add/Make) - If other than select what
table does it update/add/make?

Linked Tables are as they sound - They are a link to an outside source (excel,
access, txt file....)

You can tell what type of query you are using by looking in design mode at
the button left of the exclamation point.

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.
What is your primary key in this table? Is that primary key in the data that
you are updating from? Are you going to update via a linked table or just a
Click to expand...
[quoted text clipped - 16 lines]
Click to expand...
 
Top