I would like to learn how to automate some exporting. Right now I have a 'query1' that varies from 10-20 records. Each of these records needs a separate csv file exported for it. The csv is based on this other 'query2', but I have to go into query2 and change the criteria for each of these 10-20 records. and repeat the export after changing the criteria each time.
I started by attempting to build a macro. I have been able to figure out how to make the macro export a single csv for me after I manually change the criteria for each item, but that's all.
I am a total newbie so I am not sure how difficult this might be. I don't know any vba yet.
I would like to run query2 once for each the criteria from a field in query1, and have a csv exported for each one that has a file name based on the items from query1
Example:
Query1 contains a field called ID and it lists f1,f3,f22.....
Querry2 has the same ID field but it is filtered for only one of the ID's at a time (criteria: "f1")
I would like export query2 into f1.csv f3.csv f22.csv .....
Maybe it would be easier if someone could just tell me what the different syntax that I need to learn is, can I do this in macro or do I have to do something else... That type of info would be great for a start.
Thanks