Access TOP VALUE in query

[Carpy01]

When I set TOP VALUE to 10 and run query I get the top 12 records. Can anyone please help with this problem.


Thanks Carpy01

[weekend00]

I always get 10 when I put top 10. Not sure what is behind you scenario.

[TheShabz]

view the query in sql view and paste it in. that'll be more helpful than us guessing.

[Carpy01]

SELECT TOP 10qry_PlayScore20MostRecent.Diiff, qry_PlayScore20MostRecent.Date
FROM qry_PlayScore20MostRecent
ORDER BY qry_PlayScore20MostRecent.Diiff;

[TheShabz]

you need a space after 10.
SELECT TOP 10 qry_PlayScore.....

[Carpy01]

SELECT TOP 10 qry_PlayScore20MostRecent.Diiff, qry_PlayScore20MostRecent.Date
FROM qry_PlayScore20MostRecent
ORDER BY qry_PlayScore20MostRecent.Diiff;

Give a return of 12 records!

[TheShabz]

i dont know what to tell you. i dont see why you'd be getting 12. it must have something to do with the original query used in this one. i cant think of anything else =/

[cguzman]

Check your numbers. I'm pretty sure you have a tie.

[orange]

Can you show us the original queries? Perhaps there is something filtering/not filtering your records.
Could be a tie as cguzman suggested.