I have 4 fields that I need help with:
Zip: I need this to only export the first 5 numbers.
SSN: I don't want this to print with any spaces or dashes (-).
First Name: Anything after the first name I don't want it to print. Example John S. - I only want John.
Last Name: Same as the first name I don't want anything after the last. Example Smith JR - I only want Smith.
This query already exist, I am not looking to re invent the whole thing or use in depth visual basic, just simple formulas I can add to the criteria or build sections.