Top ten results from a query

Hi, I have created a query to show how many appointments a client has attended.  I want to see just the 'top ten' and have put 10 in the 'returns' field, but its returning 15 instead of 10.

Does anyone have any ideas why?
LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


Go to the SQL View and place Top 10 between SELECT and the first field

Dale FyeOwner, Developing Solutions LLCCommented:
when you use the TOP # predicate in your query, it will return the # based the field in your SELECT clause, and if there are duplicates then it will return those as well.  So if you want the Top 10, you may get 11, or even 15.  Look at the fields in your query and determine whether there are other fields that you can use in your Order By clause (they don't have to be in the SELECT portion of your query) which will make each record unique.  Then, when you use Top 10, you will get 10 (or less if your criteria returns less than 10 records).


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LillyCDatabase DeveloperAuthor Commented:
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Dale FyeOwner, Developing Solutions LLCCommented:
happy to help.
LillyCDatabase DeveloperAuthor Commented:
Can I just say, you explained it in a way I understood.  Not being a typical techy person I do sometimes struggle to understand the answers - so thank you again :)
Dale FyeOwner, Developing Solutions LLCCommented:
Thanks, appreciate the compliment.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.