I have to run 4 queries and save the answer after each one every week. Is there like a macro function whereby it will run the four one after each other and then save the answers itself to whatever I want to call them.
Yes, you can do that. Design your queries and save them. Then in your script, you simply paste them into the code (using EDIT->PASTE FROM). In it's simplest form it would look something like this:
;the PASTE FROM starts immediately after "qVar ="
qVar = Query
:myAlias:MyDb.DB | Code | Description |
|Check | Check |
qVar.executeQBE(":priv:answer.db") ;you can change this to be a different table name and location.
;(repeat 3 more times)