G Guest Jul 9, 2007 #1 I have a field that gives data like H-A-0012-02 I would like on the report to just display the A from the string.
I have a field that gives data like H-A-0012-02 I would like on the report to just display the A from the string.
J Jeff Boyce Jul 9, 2007 #2 Michelle If the "A" is ALWAYS in the third position, you could use something like: Mid([YourFieldName],3,1) in your query. Regards Jeff Boyce Microsoft Office/Access MVP
Michelle If the "A" is ALWAYS in the third position, you could use something like: Mid([YourFieldName],3,1) in your query. Regards Jeff Boyce Microsoft Office/Access MVP
