Hi, expert:

I attach so that my problem become more clear....:(

yrou

What I could understand from your post is that you need to get the data based on the condition of requisition and there should not be any constraint on the other field.

If the above is correct.. do write a query

select tablename.fieldname
from tablename
where table.fieldname >=: requisition.f(from fieldname comes here)
and table.fieldname <=: requisition.t(to fieldname comes here)
selectdo
write here statements if you want if u dont want leave it blank
rprt_send()
endselect

KS

I think my post is not so clear and make you confused, i need a data based on condition requisition and there should be constraint of other field.....:o

Sorry, but I undestand that you have to do a select from a table with 4 field in the selection (in the where clause). Is it?

If this is the problem:

select tablename.*
from tablename
where tablename.field1 inrange :formfield1.f and :formfield1.t
and tablename.field2 inrange :formfield2.f and :formfield2.t
and tablename.field3 inrange :formfield3.f and :formfield3.t
and tablename.field4 inrange :formfield4.f and :formfield4.t
selectdo
rprt_send()
endselect

I hope I have been able to help you.

Kind regards,

Monica:
The coding you gv me is the coding i need. Thanks for helping. Have a nice day.

regards
yroulee