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

Want to show only first 40 characters in query column

Status
Not open for further replies.
3587ch

3587ch

Technical User
Jun 19, 2009
30
US
In a query column I would like to show only the first 40 characters that have been entered into the comments field. Is this possible?

Thank you,
 
Sort by date Sort by votes
Code: 
Alias:Left([FieldName], 30)
Should do the trick ... Alias is what ever you want to call the shortened field

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
222
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
316
TrekBiker
TrekBiker
Lamar Washington
  • Locked
  • Question
Programmatically send email using only OWA
Replies
2
Views
176
Andrzejek
Andrzejek
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
260
PrimoSteve
PrimoSteve
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
360
PrimoSteve
PrimoSteve

Part and Inventory Search

Sponsor

Back
Top