Errormessage :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '2023_TafelUni.Tafels'.
Database = Access
file 1: 2023_SV9999_od / fields = tafel (numeric), name, (and other)
file 2: 2023_TafelUni / 1 field = Tafels (numeric)
Thanks for tips.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '2023_TafelUni.Tafels'.
Code:
sql = "SELECT 2023_SV999_od.*, 2023_TafelUni.Tafels, "&_
"(Select Sum(Number) FROM 2023_SV999_od) AS TotNumber, "&_
"(Select sum(Amount) FROM 2023_SV999_od) AS TotAmount, "&_
"(Select Sum(Number) FROM 2023_SV999_od WHERE tafel=2023_TafelUni.Tafels) AS TNumber "&_
"FROM 2023_TafelUni "&_
"left JOIN 2023_SV999_od ON 2023_TafelUni.Tafels=2023_SV999_od.Tafel "&_
"ORDER BY 2023_TableUni.Tafels, 2023_SV999_od.Clb, 2023_SV999_od.name ASC"
Database = Access
file 1: 2023_SV9999_od / fields = tafel (numeric), name, (and other)
file 2: 2023_TafelUni / 1 field = Tafels (numeric)
Thanks for tips.