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

Leading spaces in the field

Status
Not open for further replies.
aarellano

aarellano

MIS
Oct 22, 2007
168
US
Hello,

I have a ms access query that gives me some account numbers and their values.
In the "Account" field I have 8 spaces and then the number starts, Is there a way to get rid of the spaces and just get the number?


thank you in advance
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
556
rashmibala
R
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
1K
strongm
strongm
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
999
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
643
mikrom
mikrom
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo

Part and Inventory Search

Sponsor

Back
Top