Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select records where a field is different then the last record
Golom: I'm looking for al records where the value has changed, but only when the change was maintained for a few hours (those records that are "changed" not "in the process of changing")- chessley3
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Select records where a field is different then the last record
I have a table that is a record of values over time, because of the way the values are recored when the value is changing that record shows a value somewere between the old and new value Here is an example. Time Value1 Value2 1:00 2.5 3 2:00 2.5 3.5 3:00 2.75 4...- chessley3
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
