Update data in query field

[IanT]

Hi
I have code which opens a query and exports the data to a file. How can I get the code to update a field in the query to a specified value, for each line of data which has been exported. This value would be used to filter future data.

Thanks in advance..........