I am trying to create a query that extracts the left most 3 characters from a particular field. For example, in the Criteria line of the query pane, I want to look at the field and only show it in the results if the first three letters in the field are "Feb". The entire field may read "Feb, May, Aug, Nov" or it could read "Mar, June, Sep, Dec", or some other quarterly string. I am trying to extract the first three letters, because it is a fairly large table and the data entry is not consistent through out. I can reasonable expect that the first three letters are consistant, so that is why I only want to look those characters.

Thanks,

David

Well, since you didn't give any field names, you will have to change it to whatever is applicable. Use the left function like the following:

Left([Fieldname],3)

Regards,

Beth M

Thanks Beth M,

I spent about an hour trying to figure this one out. Thanks for saving me more frustrations.

David

My pleasure :)