Skip to Content
Former Member
Apr 27, 2010 at 06:30 PM

if condition on forms


my requirement is ( i want to display the serial no and qty of serial no) i have serial no now(this vale is coming from table) and i need to display quantity value for serial no.

1) if i have serial no(43254) then qty of serial is 1

2)if we have single serial no like ( 21324-) then it is dummy serial no we don't want to display this serial no, but we need to display the quantity of serial ( even if we have more than one serial no then i need to display sum of qty without displaying the dummy serial no) .

3) if we have duplicate serial no then we don't need to display the serial no , but we need to display qty of serial is '0'.

please help on it