This is just a very small, entry-level VB 6 /MS Access 2000 project.
I can write SQL, but I don't know VB syntax, and I want to loop a couple of queries. I need an example, a template, of how to do the following:
I have a table with an series of weekly dates. I want to start with the first date in the table and assign it to a variable in two SQL query statements.
I want to run the each of the two queries. Then I want to assign the next date from the table to the queries and run them again. I need to loop the queries by each date in the table until we reach the last date in the table.
I need a detailed example of how to do this.
I need each line of VB thoroughly documented. Thorough documentation is the most important thing.
You can use whatever table names, variable names, and query names you like, as long as each line is thoroughly documented.