Export query and name by data in field 1

[mdctsg]

I need to export my query to a txt file and have it named referenced by the data in my field 1. The field 1 is just a julian date with UP in the front and an A on the rear. Each day the date will change but the UP and A will be constant. So today it will be example UP2005166A and tomorrow it will be UP2005167A. Any suggestions how I can do this? I can't just just todays date becasue the information may not be retrieved until later. So if I may need the info for 2005166 on day 189 and so forth. This is why I need to get it from my field 1

Thanks
Bob

 

[mdctsg]

Sorry I posted some incorrect information. It is a table not a query I am exporting.

Thanks
Bob