Detect Change

jking · May 27th, 2005, 12:49 AM

How can I query to select the last change in a column?

tbl columns DateAndTime, Tag, Value

For many rows in tbl, value remains same. I want to select row where value changed.

----------------
jking

shahchi1 · May 27th, 2005, 12:49 PM

Jim, One way to do this is set your DateandTime column to GETDATE() or NOW() (if you are using Access) everytime you do update to your value field. Then you can query your database for last 24 hours how many rows were updated.

jking · May 27th, 2005, 05:57 PM

I don't create the data, I query and report the data, so updates don't apply.

Quote:

quote:Originally posted by shahchi1
... set your DateandTime column to GETDATE() or NOW() (if you are using Access) everytime you do update to your value field. Then you can query your database for last 24 hours how many rows were updated.