Update Query Question

[SteveGr]

Hi all,

I have a Table that hold records that I want to update with a calculation. I created an update query that changes these records to the value I want. (performing a calculation *1.5)
The problem is that every time I run the Query it performs another calculation to all the records not just the new ones that were recently added. I only want to perform a calculation once.
And I have new records being added daily.

Anyone know how to apply this calculation to a new record automatically without user intervention and without changing any other records in my table?

Thanks, Stevegr

 

[Rob.Mills]

There's several ways you could go about doing that and I'm not sure what the most efficient way is.

One way is to put a field in your table that is Yes/No and in the update query you could set it up so that when the query runs it would mark this field yes and then set the criteria for this field to No.

That way it only updates records which have no in that field and then set it to say yes.

Another thing you could do is put a date field in the table whose default value is Date(). And then you could say only update records entered after a certain date.