Hi all, I have a query that uses and ODBC connection to get data into an Access table. I also have a button that outputs that to a server location as a text file. What I need is everytime you hit the output to button it names the resulting text file sequentially. However the first part of the outputed file needs to be constant and then after that sequentially number it I.E first time I output the file its ASNI0001.TXT the next time its ASNI0002.TXT and so on is this possible?
Thanks for your help, Steve.
Thanks for your help, Steve.
