Using a left function in a query

[michaelak117]

Does anyone know if its possible to use a left function to change the entire field in a query. I have a dates that come in as Mar-09/fwd and I would like only to capture the "Mar-09" portion. I just dont know where I would put the function to make it work and also how to specify the field or "cells" as you would in excel. Excel is =left(d2,6). First refering to cell and second to number of digits. Help would be much appreciated. Thanks

Mike

 

[boblarson]

You can do this.

Create your own field in a query by typing into the field name area:

YourNewFieldName:Left([YourFieldWithTheOtherData],6)

and there you go.

 

[michaelak117]

That worked great, Thanks alot. I def should of thought of that. Take care, thanks makin it convenient.

 

[boblarson]

That worked great, Thanks alot. I def should of thought of that. Take care, thanks makin it convenient.

No problem