ok im having real trouble deciding on were this goes, as its programming in Visual Basic, but its an SQL command im having the trouble with, so im gonna do both <grins>
Ok, i have an SQL statements like so -
statement = "SELECT Albumname, DIR, Mix FROM BonkersListAndDir WHERE Albumname LIKE '' ORDER BY Albumname"
but i need to insert the data from a variable named "text" into were the LIKE is and nothing i do seems to working, ive treid
LIKE '' & Text
LIKE Text & ''
LIKE ' & Text & '
but cant seem to get it in, if anyone would be kind enough to show me how to rectify this problem will be most greatful, thank
Devon.