Hi Helen

> Yes, this should do them both:
>
> select m."Cust ID", m."Deliver Date", m."Grand Total"
> from "DR" m
> where m."Cust ID" = 205
> and m."Grand Total" =
> (select MAX(d."Grand Total")
> from "DR" d
> where d."Cust ID" = 205)
>
> select m."Cust ID", m."Deliver Date", m."Grand Total"
> from "DR" m
> where m."Cust ID" = 205
> and m."Grand Total" =
> (select MIN(d."Grand Total")
> from "DR" d
> where d."Cust ID" = 205)
>

Thanks a lot! But for the sake of learning may I ask if my original
script is wrong? and why is it the first one work while the second
makes my FB hangs and the only difference between the two sql
statement is the '<' and the '<'.

Thanks again.

Regards,
James