 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006How do I show only a specific munber of characters?
Hello, I have a simple table. One field (CustomerID) in that table contains 11 characters. I've created a report that shows the various fields I need, but I only need to show the first 5 characters from the CustomerID field. How would I go about this? Thank you! Try this in the field =Left([CustomerID],5) Or in a query Select Left([CustomerID],5) As NewName From TableName  Signature\\// Live Long and Prosper \\// BS"D > Hello, > [quoted text clipped - 4 lines] > > Thank you! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.