Hello.
I have the following task:
Suppose that you have a recordset that contains the following:
DATE
Color1
Offset1
Okay. Now suppose you want to extract from this recordset 15 records only
that are just before the record whose Color1 and Offset1 matches those 15
records.
Example:
Suppose Record number 98 is our REFERENCE record. Color1 = "RED" and Offset1
= 6.
I would like to retrieve the most recent 15 records just prior to record 98
that also have Color1 = "RED" and Offset1 = 6.
How might this be accomplished?
Thank you in advance. :-)
Rick
Language: VB6
(Experience: Brown Belt Novice)
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
