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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trim length of data to move from one DB to another 1

Status
Not open for further replies.
redbase

redbase

Technical User
Nov 21, 2002
21
GB
Hi

I am moving data from one database to another and I am using the follwing method to remove commas:

rs2!MyField = Replace(rs1!Reference, ",", "")

I also need to reduce the field length to a max of 35 characters. How can I do this?

Thank you

 
Sort by date Sort by votes
left(rs2!myfield, 35)

--------------------
Procrastinate Now!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
184
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
436
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
348
Andrzejek
Andrzejek
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
416
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
250
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top