n 21 Aug, 21:57, Paul < XXXX@XXXXX.COM > wrote:
Whoa there Paul! Where did all these extra fields come from?
You told us that your table had only 4 fields and now you are showing
us a query which references 5 fields, two of which are not in the
Now, I have already written you a detailed post explaining exactly
what you need to so. In particular, you have to do what I said in that
post, which is to "define what is meant by next". I gave some examples
of how to do this. All the time you leave it to chance, your task
remains impossible and there is no point asking how to do the
Now I notice that you are ordering by a column called timestamp. Now
if you take that a bit further and make sure that you have a constant
and unique ORDER BY clause, precisely as I have already explained in
my post, you can implement a "next picture" process.