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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need to remove part of data in field
I have a an excel file that I imported into Access. The file was badly formatted and I need to remove some of the data from the second field. For example, one field looks like this:T 30042178901. In this case, I need to remove the T and the spaces just leaving the number. However, not...- dassaf
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
