Pull part of a field

[Michelle]

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.

 

[Jeff Boyce]

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