Dear whom can help

Good day to you, I was wondering someone has the time with for this little problem. I am try to use VBA in Access to run a query like this one

SELECT
E1_Sep03.CAS, E1_Sep03.Name, E1_Sep03.RT, E2_Sep03.RT, E3_Sep03.RT FROM (E1_Sep03 INNER JOIN E2_Sep03 ON E1_Sep03.CAS = E2_Sep03.CAS) INNER JOIN E3_Sep03 ON E1_Sep03.CAS = E3_Sep03.CAS;

Where E1_Sep03, E2_Sep03 and E3_Sep03 are the tables.

I have another 48 such tables, ( in multiples of 3 ), hence I would like to Automate the process to make it faster, however I am very much a novice, and I tried something like this


Dim StrSQL As String


StrSQL = "SELECT E1_Sep03.CAS, E1_Sep03.Name, E1_Sep03.RT, E2_Sep03.RT, E3_Sep03.RT FROM (E1_Sep03 INNER JOIN E2_Sep03 ON E1_Sep03.CAS = E2_Sep03.CAS) INNER JOIN E3_Sep03 ON E1_Sep03.CAS = E3_Sep03.CAS;"

DoCmd.RunSQL StrSQL

However I couldn't get it to work, I really don't understand
could you please help
Thank you in advance
D_Namm