I set one of the field to amounts and I need to do a search to see if the amount is between two numbers like is it greater than 100 but less than 500 can anyone help me with this ?
OK
I used
if ($in{'Partnum-gt'}) { $in{'Partnum-gt'} = $in{'Partnum-gt'} - .01; }
if ($in{'Partnum-lt'}) {$in{'Partnum-lt'} = $in{'Partnum-lt'} + .01; }
But when I do a search it works if I do from 0 - 200 or 0 - 400 but if I try 200 - 400 it dont work (help)
OK
I used
if ($in{'Partnum-gt'}) { $in{'Partnum-gt'} = $in{'Partnum-gt'} - .01; }
if ($in{'Partnum-lt'}) {$in{'Partnum-lt'} = $in{'Partnum-lt'} + .01; }
But when I do a search it works if I do from 0 - 200 or 0 - 400 but if I try 200 - 400 it dont work (help)
Seach < or > (Help)