I have a logic field eg. pay,
if .NULL. means no need to pay,
.T. means customer paid thier bill already
.F. means customer no yet pay

I have a parameter view to let users select the records set :

SELE * FROM customer ;
WHERE BETWEEN(pay,?mPay1,?mPay2)


IF users select PAY, mpay1 = .T. and mpay2 = .T.
IF users select NO PAY , mPay1 = .f. and mpay2 = .F.,

But problem is if users select ALL, how to set the mpay1 and mpay?

Any advise.

TIA.