What is this ?

[GlennG]

Hello all,

I am slowly trying to learn Access and I found this bit of code which I find completely unbelievable. Do I have to learn how to write this stuff ? Is there a tool to help me reproduce this or create this ? I'm used to VBA Excell and that makes sense to me but this !!!! What is it ???

chaine = "SELECT LOCAL, IIf(PRODUITS='3000' OR PRODUITS='7100','VOR.N','VNOIR.N') AS PRODUIT, Sum(MARGE) AS DATA INTO MOIS_VISA " & _
"FROM INP_VISA INNER JOIN CONV_LOCAL ON INP_VISA.LOCAL_INP = CONV_LOCAL.LOCAL_INP " & _
"GROUP BY CONV_LOCAL.LOCAL, IIf(PRODUITS='3000' OR PRODUITS='7100','VOR.N','VNOIR.N'), PRODUITS " & _
"HAVING Sum(MARGE) <> 0 And PRODUITS In ('0100','2000','3000','5000','7000','7100') " & _
"ORDER BY CONV_LOCAL.LOCAL, IIf(PRODUITS='3000' OR PRODUITS='7100','VOR.N','VNOIR.N')"
dbs.Execute chaine

 

[bmacr]

It's SQL code, contained in a variable. Probably the best tool for writing SQL is the query builder in Access. Create a new query, add a couple of tables and drag some fields into the lower part of the window. Now go to the VIEW menu and choose SQL view. There you will find the code you just 'wrote'. You can create joins, add criteria, create calculated fields, all graphically in the query builder. You can use this as the basis for your variable in VBA, with a little tweaking.

 

[GlennG]

Wow !!!

Big Big Thank you for your help..... I now have hope ! I might actually get thru this alive !

Glenn