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

Concatenate with tab character between columns

Status
Not open for further replies.
dead7

dead7

Programmer
Joined
Jun 8, 2004
Messages
79
Location
US
Can I concatenate columns in a database with a tab between each column.
If so is there a special tab charater to use.

sort like this
column1<tab>column2<tab>column3
 
Sort by date Sort by votes
Columns as in fields?
[tt]strString=Field1 & Chr(09) & Field2 & Chr(09) & Field3[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
2K
dhookom
dhookom
BJZeak
  • Locked
  • Question Question
Struggling with finding an answer to a simple question
Replies
5
Views
958
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question Question
Running query with parameter from Inputbox
Replies
8
Views
1K
TrekBiker
TrekBiker
caykamanj1966
  • Locked
  • Question Question
Help With Search Form Results
Replies
15
Views
990
caykamanj1966
caykamanj1966
rccline
  • Locked
  • Question Question
Highlighting Duplicates with Conditional Formatting
2
Replies
26
Views
2K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top