Need Help Assigning File Name

S

Stryker22150

I need help with assigning a file name, based on a value in a field.
The same query supports 3 different reports. The file is exported as a
delimited text file. I would like to assign a file name based on a
field value.

TIA
 
S

Stryker22150

Steve;

Thank you for the response; however, that was not what I was looking
for. I have a parameter query that supports 4 different reports. Each
of the reporrts has a seperate file name. When the rotine runs I would
like to be able to dump the file with a name associated to the
parameter value.

An example if <field_name> is =2 then SaveAs ABC.txt or If <field_name>
=3 then SaveAs XYZ.txt

TIA
 
Top