Separate results of a query by tab stops.

[Jeanette]

Hi, Is it possible to separate results of a query by tab stobs. I have a query which give me a list of people to distribute a memo to. I need each person on the list printed across a report separated by tab stops. Thanks in advance.

 

[llkhoutx]

If there's an ASCII code for a tab stop, concantenate it between the names.

 

[raskew]

Something like this (from the debug window):

TB = Chr(9) ' Define tab.
MyStr = "The Quick Brown Fox"
? MyStr
The Quick Brown Fox
MyStr = "The " & TB & "quick " & TB & "brown " & TB & "fox"
? myStr
The     quick   brown   fox

 

[Pat Hartman]

This article should get you started in the right direction:

Q141624 - ACC How to Concatenate a List of Items from a Many-Side Table