SELECT * FROM dep WHERE balance < lnBalance ORDER BY dateand manually inspect the result to see if there are any records in your date range.
USE dep INDEX ON acno TO lnAcnot lnAmount = 95 mdate = {^2005-10-10} mdate1 = {^2006-03-31} BROW FOR balance < lnBalance AND BETWEEN(date,mdate,mdate1)Again, from what I see, I think the "problem" is that there are no matching records in your time frame. I don't see my strictdate suggestion making a difference but, as mentioned in another part of the thread, "it can't hurt."
>set date british >use dep >index on acno to lnAcnot >lnAmount=95 >mdate=ctod("10/10/2005") >mdate1=ctod("31/03/2006") >brow for balance<lnBalance and date>=mdate and date<=mdate1 > >No result. >>But if I write
>brow for balance<lnBalance >>