Eliminating certain codes

[PBTX]

Hello;

I need to have certain information from my report to not pull and I am not sure how to do this. I have Union Codes that I am pulling the data from which is a 4 digit / letter code SO32. If it is less than 4 characters, I do not want it to pull? Can someone help me with the code to make this happen?

Thanks

 

[lbass]

Use a record selection formula like this:

Len({table.code}) >= 4

-LB

 

[PBTX]

Good morning

The formula did exactly what I needed it to do, but it disrupted my parameters. It is completely ignoring my parameters and returning every record clear back to 1999. The parameters were set for period end date 10/15/11 - 10/15/11 and job 4250.

Thank you,

 

[lbass]

Adding that to your formula would not undo the effects of other parameters, unless the formula is set up incorrectly, so what is the exact formula you used?

-LB

 

[PBTX]

Fixed this one

 

[PBTX]

Forgot to put in and.

Thank you