Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How too remove text with query

Status
Not open for further replies.
cornerme

cornerme

IS-IT--Management
Nov 24, 2009
4
US
I have computer names that are currently in a table in this format:

\\computername
I want to trim the \\ from the field with a query.

I know it sounds easy and most likely is to most but I am a beginner.

Any help would be appreciated.
 
Sort by date Sort by votes
Mid([computer name],3)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
224
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
302
TrekBiker
TrekBiker
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
117
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
219
dhookom
dhookom
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
274
BJZeak
BJZeak

Part and Inventory Search

Sponsor

Back
Top