Export Query to Excel Question 1

[SMHSleepy]

Hi folks, I have a query which I use to periodically export data to an Excel file. I use the <DoCmd.TransferText acExportDelim> command to do this. After I do the export, I would like to update the checkbox field in one of the tables so that it doesn't get exported again when I run the command. I've already put the condition in my query to exclude records with this checkbox selected but right now I have to manually check them after doing each export. Can anyone help?

 

[PHV]

I'd run an UPDATE query with the same WHERE clause as the export query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SMHSleepy]

OMG, I feel like such a newb. Thank you! All I did was make a copy of my query, change it to an update query and put change to "true" in the checkbox. Simple but brilliant, thanks again!