I am filtering a field called "OPEN" WITH RANGE 1...10 i m getting 487 records found from that record i want to filter "AMT" field with range 5000...10000 couldn't do it trying extend found set and constrain found set getting erratic results kindly help me enclosing file down plz

 

Edited December 19, 20196 yr by Dr.Gopala krishnam raju AMBATI

Does the attached work for you?

Test.fmp12

understood wat u did 

 

u took 487 from total

i want to filter first 487 from 487 it should filter out 5000...1000

hope m clear

Edited December 19, 20196 yr by Dr.Gopala krishnam raju AMBATI

To find records where Open is within the range specified in gOpenRange and AMT is not within the range specified in gAMTRange, change the script to:

Enter Find Mode [ ]
Set Field [ Test::Open; Test::gOpenRange ] 
New Record/Request
Set Field [ Test::AMT; Test::gAMTRange ] 
Omit Record
Perform Find [ ]

 

35 minutes ago, comment said:

To find records where Open is within the range specified in gOpenRange and AMT is not within the range specified in gAMTRange, change the script to:

Enter Find Mode [ ]
Set Field [ Test::Open; Test::gOpenRange ] 
New Record/Request
Set Field [ Test::AMT; Test::gAMTRange ] 
Omit Record
Perform Find [ ]

 

 not working 

9 minutes ago, Dr.Gopala krishnam raju AMBATI said:

not working 

Not a good description. Try something like "this finds a record with the values of ... (that should not have been found)" or "this does not find a record with the values of ... (that should have been found)".

we are filtering 487 from total  and from 487 can't we filter  

I am afraid you're not making your requirement clear enough. Consider the following example:

SerialID	Open	AMT
1	0	2500
2	0	7500
3	0	15000
4	5	2500
5	5	7500
6	5	15000
7	15	2500
8	15	7500
9	15	15000

Given a range of 1..10 for Open and a range of 5000..10000 for AMT, which of the above records should be found (and why)?

43 minutes ago, comment said:

I am afraid you're not making your requirement clear enough. Consider the following example:

SerialID	Open	AMT
1	0	2500
2	0	7500
3	0	15000
4	5	2500
5	5	7500
6	5	15000
7	15	2500
8	15	7500
9	15	15000

Given a range of 1..10 for Open and a range of 5000..10000 for AMT, which of the above records should be found (and why)?

ABOVE database is indian stock exchange  shares database as a screening tool i made this file so that i can know cheapest share with maximum profit so first i am filtering from 1 to 10 priced shares then i want filter shares which are making profit between 5000 to 1000 rupees hope u understand what i meant

FILTERED FROM 487  I changed omit and used constrain got it  thanks for concern #comment