Novice: How to save results of query in tsv format

[danb]

Hi,

I'm new to queries. I've managed to build a very simple query which joins two tables. How to I save these results so that I can export a tsv file from them?

(I'm using Access 2000).

Thanks very much for your help...

 

[danb]

No problem, done it.

From design view of query, go to Query > Make-Table Query.

 

[Rickster57]

Query

Run your query. Go up to File>Export> At the bottom dropdown box choose Save File As Type to Text. At the lower right of the Form choose Export All. Then choose Tab delimited.

Good lcuk