export to text file

[Maura]

Can anyone help export a query to a text file in a
different format
My query has 3 fields, and i need to export it to a text
file in tabular format.
Anyone know VBA to do that???

 

[Jim/Chris]

Highlight the query and do File/Export
In the "Save as file type" select text
The Text Export Wizard opens
follow the menusIf youy want to save the Spec or make
additional changes click the advanced button

Jim

 

[Maura]

Thanks dan,
the format im trying to print to text is a little more
complicated. i think i have to use some VBA code.
I have a form that allows the user to select the value of
the first field, then i need to list all of the field2 and
field3 that apply in this format:


field2-1
1 1 1 1 1 1 1 1 1 1 1 1 1
(number of field3's)
field3-1
field3-2
field3-3

field2-2
1 1 1 1 1 1 1 1 1 1 1 1 1
4
field3-4
field3-5
field3-6
field3-7

if anyone knows how to help me out i would really
appreciate it!