"Jigal van Hemert" <[EMAIL PROTECTED]> wrote on 01/24/2005 03:10:40 AM:
> > so it will be like this
> > no date price limit
> > 01 1/1/05 5000 100
> > 02 1/2/05 5010 100
> > 03 1/3/05 5020 60 **
> > 04 1/6/05 5010 100 ** there are 3 days difference
> >
> > but how do make a query to check for rec
> so it will be like this
> no date price limit
> 01 1/1/05 5000 100
> 02 1/2/05 5010 100
> 03 1/3/05 5020 60 **
> 04 1/6/05 5010 100 ** there are 3 days difference
>
> but how do make a query to check for record no 04 with 03
> how do i retrieved the 1/3/05 date and the price
You actually want t
