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 derfloh 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
Joined
Nov 24, 2009
Messages
4
Location
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
Thank you very much PHV.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question Question
Navigation Bar is too short to read
Replies
5
Views
855
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Running query with parameter from Inputbox
Replies
8
Views
1K
TrekBiker
TrekBiker
I
  • Locked
  • Question Question
How to get 2 codes to work together.
Replies
6
Views
1K
hermanlaksko
hermanlaksko
caykamanj1966
  • Locked
  • Question Question
Hyperlink Text of a field
Replies
1
Views
381
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question Question
Use Crosstab query in subform
Replies
9
Views
992
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top