How to select part of a field

[wutaguy]

I have joined 3 tables using the query design and I have 3 different fileds. There are fields that have information that I don't need. e.g. I don't want the first 10 characters of field 1. How do I do this in query design (even in SQL view). Or do I need to do this in the table itself before joining the table. Hope my question makes sense. Thanks for any input.

 

[RuralGuy]

That is one of the powers of a query so go ahead and use it. Make a new field with a function:
NewField:Right([Field1],Len([Field1])-10)