Help with length of text in my colums in query

[mcmba]

I need some help! I have created an Access query that creates a file that I will use to upload to another system. The system that I am sending this data to only allows 30 characters in one of the columns I am uploading to. So it is going to truncate any of the fields I send over 30 characters to 30 characters. However, I can load characters 31+ in the next column. But I don't know how to pull just the text from 31 and beyond.

For example: Here's my output in the cell:
"Antimalarial whole cell inhibitors - Malaria".

When I upload this, the system I am uploading to will truncate it to only 30 characters. So in the column next to this one in the upload I need to put:
"tors - Malaria"

How do I pull text characters at position 31 and beyond????

Anyhelp would be greatly appreciated!!! Thanks in advance!

 

[Joe4]

Use the MID function, MID(Field,Starting Point,Length)
i.e
MID([FieldName],31,LEN([FieldName])-30)

 

[mcmba]

Thanks so much, I am getting an error saying "The specified field [project_desc] could refer to more than one table listed in the from clause of your SQL statement"....how do I specifiy which exact table to pull the project description from. It is three tables of my query.

Sorry to be such a novice!!!!

 

[Joe4]

Go into the Query Builder and build the expression using the Expression Builder. If you build it in there, selecting the field you wish to use, it shouldn't have any confusion over which field to apply it to.

 

[mcmba]

Awesome! Thanks!!!