Hello all,
I have a report which displays a number of fields from a table. One of the fields is a delivery address, of which the first line is a dock number (##-##), then the rest is the standard address. What I need to do is find a way to have my report display this field without the first 5 characters.
I am using =right([field],2) in another part of the report to display only the last two characters in the field, and this works great.
Now I need another field to display everything but the first 5 characters, and have been having trouble finding the correct expression. Since the addresses are not fixed length, I cannot use a fixed value to pull everything up to the first 5.
Is there an easy command for this?
TIA,
Adam