Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Eliminating certain codes

Status
Not open for further replies.

PBTX

Technical User
Nov 1, 2011
17
US
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
 
Use a record selection formula like this:

Len({table.code}) >= 4

-LB
 
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,
 
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
 
Forgot to put in and.

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top