A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Top Ten Records Displayed by a value



 
 
Thread Tools Display Modes
  #1  
Old November 27th, 2006, 05:08 PM posted to microsoft.public.access.queries
K
external usenet poster
 
Posts: 287
Default Top Ten Records Displayed by a value

Good day,

I am trying to create a report that is based on a query. How do I Only
display the top ten items by highest volume?

Any help would be apprceiated.
  #2  
Old November 27th, 2006, 05:12 PM posted to microsoft.public.access.queries
myriam
external usenet poster
 
Posts: 1
Default Top Ten Records Displayed by a value

je ne comprends pas
"K" a écrit dans le message de news:
...
Good day,

I am trying to create a report that is based on a query. How do I Only
display the top ten items by highest volume?

Any help would be apprceiated.



  #3  
Old November 27th, 2006, 05:31 PM posted to microsoft.public.access.queries
K
external usenet poster
 
Posts: 287
Default Top Ten Records Displayed by a value

I am creating a report based on a query. How do only display the top ten
records by the highest volume

"myriam" wrote:

je ne comprends pas
"K" a écrit dans le message de news:
...
Good day,

I am trying to create a report that is based on a query. How do I Only
display the top ten items by highest volume?

Any help would be apprceiated.




  #4  
Old November 27th, 2006, 05:41 PM posted to microsoft.public.access.queries
MJatAflac
external usenet poster
 
Posts: 15
Default Top Ten Records Displayed by a value

You can set this in the actual query itself.
Open the properties window in the query design view and then you should see
"Top Values" in the properties. Simply type in the number 10 in that property
and you should be good to go. This can be a little unpredictable at times but
it generally behaves as expected.

Hope this helps.
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office


"K" wrote:

I am creating a report based on a query. How do only display the top ten
records by the highest volume

"myriam" wrote:

je ne comprends pas
"K" a écrit dans le message de news:
...
Good day,

I am trying to create a report that is based on a query. How do I Only
display the top ten items by highest volume?

Any help would be apprceiated.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.