Hi,
I am exporting data from a table to Excel files (in a loop) - called location101.xls, location102.xls etc from a docmd.outputto in a function.
In this function I have a counter that increments in each loop that updates the file name.
What I would like to do is pass this counter number from my function to my query so it will select the location field as 1 then 2 then 3 and so on.... as my function loops.
Can anyone help????
TIA
I am exporting data from a table to Excel files (in a loop) - called location101.xls, location102.xls etc from a docmd.outputto in a function.
In this function I have a counter that increments in each loop that updates the file name.
What I would like to do is pass this counter number from my function to my query so it will select the location field as 1 then 2 then 3 and so on.... as my function loops.
Can anyone help????
TIA