Ok im having trouble with an SQL Command, i have to assign the text from List2.Text into a LIKE section of my SQL statement.
Expand|Select|Wrap|Line Numbers
- statement = "SELECT Albumname, DIR, Mix FROM BonkersListAndDir WHERE Albumname LIKE '' ORDER BY Albumname"
WHERE Albumname LIKE 'List2.Text'
WHERE Albumname LIKE '' & List2.Text
WHERE Albumname LIKE List2.text & ''
but also i need to add the % wildcard at the end of List2.text, ive also tried assigning List2.text to a var,
Expand|Select|Wrap|Line Numbers
- Text = List2.Text & "%"
- statement = "SELECT Albumname, DIR, Mix FROM BonkersListAndDir WHERE Albumname LIKE '' ORDER BY Albumname"