---

Hello,

I use a SQL-string to get data from an Access-database.

SQLstring7 = "SELECT * From Tracks ORDER BY Tracks.Tracktitel ASC;"

Now I want to make an extra selection on this string. Only display the
records where the value in the field Volgorde is "00"
(The field Volgorde is a Text-field).

I tried everything but I only get (syntax)errors.

Thanks,

Susan

---

I news:eikt98$2on$1@news3.zwoll1.ov.home.nl,
skrev Susan <ark312@home.nl>:
> Hello,
>
> I use a SQL-string to get data from an Access-database.
>
> SQLstring7 = "SELECT * From Tracks ORDER BY Tracks.Tracktitel ASC;"
>
> Now I want to make an extra selection on this string. Only display the
> records where the value in the field Volgorde is "00"
> (The field Volgorde is a Text-field).

SQLstring = "SELECT * From Tracks WHERE Volgorde = '00' ORDER BY
Tracks.Tracktitel ASC;"

Note single quotation marks round '00', possible cause of error.

--
mvh
Jens Vestergaard (mailadr i dette indlæg er ikke gyldig!)
Døgnets jernbanenyheder: www.railsoft.dk/medier.asp
Nu med afstemninger!