I'm trying to code a macro in Access where i can build any type of query to query the database, whcih can be saved and executed when required. Also i wanted to export the data to an Excel sheet.
I started coding this macro and ended up sucessfully to a point where can build only select queries and export them to Excel. I used Access 2003.
Can anyone help me with the coding where in i can build and execute join queries too? I want to change this interface completely and should also be able to choose multiple tables to build join queries by choosing selected fields of a table (like a wizard interface), use comparison operators like NOT, AND, OR, sort fields, group by, order by functions like in the screenshots attached.
I am entirely new to coding macros in Access. I know VB coding and can do it Excel to some extent.
PLEASE