rito1
asked on
SELECT TOP 1 Returning more than 1 record - MS Access
Hi All,
Can anyone see why the following SQL would ignore my request of only returning 1 record and returns multiple records in MS Access?
Many thanks,
Rit
Can anyone see why the following SQL would ignore my request of only returning 1 record and returns multiple records in MS Access?
Many thanks,
Rit
SELECT TOP 1 tblQuestions.questionID AS nextQuestionID
FROM tblQuestions
WHERE (((tblQuestions.questionID)>[paramQuestionID]) AND ((tblQuestions.removed)=0))
ORDER BY tblQuestions.Seqorder;
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
It seems to be because there are multiple instances of the Seqorder value. But this has been implemented by design. But I only want the first one it comes across :-(
Yes that would be exactly right - since you only want the first one it comes across, is the order important on Seqorder value?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks all. I sorted this issue out last night (not that I can remember how exactly now) :-)
I guess you used the solution above!
/gustav
/gustav
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://stackoverflow.com/questions/887787/access-sql-using-top-5-returning-more-than-5-results