needmoremoney
Technical User
Is there a way to filter out a complete line of records based on one field?
Example
Jobcode Id Name Amount1 Amount2
1 12 JH 123.09 333.22
1 12 JH 333.34 543.02
11 HK 222.22 1211.03
3 11 HK 233.33 333.33
5 32 AX 234.23 233.11
See.. for the third roll, I want to omit the entire line because there is no jobcode. The jobcode field is a string field. I tried this through the select expert but couldn't get it working.
Any ideas? Thanks much..
Example
Jobcode Id Name Amount1 Amount2
1 12 JH 123.09 333.22
1 12 JH 333.34 543.02
11 HK 222.22 1211.03
3 11 HK 233.33 333.33
5 32 AX 234.23 233.11
See.. for the third roll, I want to omit the entire line because there is no jobcode. The jobcode field is a string field. I tried this through the select expert but couldn't get it working.
Any ideas? Thanks much..