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

Control the text format

Status
Not open for further replies.
sabavno

sabavno

Programmer
Jul 25, 2002
381
CA
Hi

I want to send a query result to the text file. But I want to be able to control spaces between the columns.

What should I do?
 
Sort by date Sort by votes
The best thing I can think of for this is to create a report based on the query, formated as you like, and then output the report instead....You will get the same result, but you can then control the format. The secret to creativity is knowing how to hide your sources. - Albert Einstein [spin]

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
752
Kennelbloke
Kennelbloke
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
479
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
707
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
356
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top