Filling a dataset with randomly chosen records

[Guest]

I am filling a dataset in VB.NET with randomly chosen records from a table in
an Access Database. I use the following SQL statement that works perfectly
when I test it out in Access. Unfortunately, it does not work the same way
when I use it to configure my dataAdapter in VB.NET

SELECT Problem
FROM tblX
WHERE (Skill = ?)
ORDER By Rnd(ID)

Any ideas?

Thanks,
Jennifer Yellman Quynn
Motivational Assessment

 

[Van T. Dinh]

The Rnd() function is only available if you run the SQL in Access, not from
outside.

Sorry, don't know enough of VB.Net to advise. Suggest you re-post in one of
the VB.Net newsgroups.