Hello,
How to translate the following query to vba so I can use it inside a module to open a recordset.
I have tried:
SQL = "SELECT DISTINCT ConcatRelated(tbl_citation_symbols.id,tbl_citation_symbols,tbl_citation_symbols.symbol like '*' & [symbol] & '*'') AS Expr1, tbl_citation_symbols.symbol FROM tbl_citation_symbols"
thank you,
Mila
How to translate the following query to vba so I can use it inside a module to open a recordset.
Code:
SELECT DISTINCT ConcatRelated("id","tbl_citation_symbols","symbol like '*" & [symbol] & "*'") AS Expr1, tbl_citation_symbols.symbol
FROM tbl_citation_symbols;
I have tried:
SQL = "SELECT DISTINCT ConcatRelated(tbl_citation_symbols.id,tbl_citation_symbols,tbl_citation_symbols.symbol like '*' & [symbol] & '*'') AS Expr1, tbl_citation_symbols.symbol FROM tbl_citation_symbols"
thank you,
Mila
Last edited: