[access] strSQL a capo

[alexxxb]

Risolto: bisogna utilizzare il simbolo _ solo dopo la key "&".
Esempio sulla mia stringa:

strSQL = "SELECT * FROM (select DISTINCT barcodeven&'-'&max(sconto1)as maggiore from Tab_Art_Vend1 WHERE ((LISTINO NOT LIKE '" & Forms!Pannello!Testo472 & "*" & "') and (LISTINO NOT LIKE '" & Forms!Pannello!Testo273 & "*" & "') and (LISTINO <> 'OLD') and (LISTINO NOT LIKE '" & Forms!Pannello!Testo486 & "*" & "') and (LISTINO NOT LIKE '" & _
Forms!Pannello!Testo461 & "*" & "') and ((LISTINO = '" & Forms!Pannello!Testo271 & "') or (LISTINO LIKE '" & Forms!Pannello!Testo470 & "*" & "') or (LISTINO LIKE '" & _
Forms!Pannello!Testo463 & "*" & "') or (LISTINO LIKE '" & Forms!Pannello!Testo465 & "*" & "'))) group by barcodeven)as tab1 left join tab_art_vend1 as tab2 on tab1.maggiore = tab2.barcodeven&'-'&sconto1 WHERE BARCODEven= '" & _
frm!barcode1 & "' and (LISTINO LIKE '" & Forms!Pannello!Testo271 & "*" & "' or LISTINO LIKE '" & Forms!Pannello!Testo470 & "*" & "' or LISTINO LIKE '" & _
Forms!Pannello!Testo463 & "*" & "' or LISTINO LIKE '" & Forms!Pannello!Testo465 & "*" & "')"