Hur skriver jag?
SQL = "SELECT TOP 20 intID, dteCreated, strName, strText " _
& " FROM [news] WHERE strText >= 200 tecken ORDER BY dteCreated DESC;"
2 svar · 210 visningar · startad av Eclipse
Hur skriver jag?
SQL = "SELECT TOP 20 intID, dteCreated, strName, strText " _
& " FROM [news] WHERE strText >= 200 tecken ORDER BY dteCreated DESC;"
Access?
SELECT TOP 20 intID, dteCreated, strName, strText
FROM news
WHERE len(strText) >= 200
ORDER BY dteCreated DESC
Fortfarande Access, sorry! Tack.