How do I show only a specific munber of characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top