1.Query the information you need
2.Build a report based on that query that has the Feilds all in the right places.
3.Output the Report To a text file using the Export Function...
In a Form It would look Like
rivate Sub Command4_Click()
On Error GoTo Err_Command4_Click
Dim stDocName As String
stDocName = "Generic Report"
DoCmd.OutputTo acReport, stDocName
Exit_Command4_Click:
Exit Sub
Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click
End Sub