The top 4 value in a report

  • Thread starter Thread starter pippo
  • Start date Start date
P

pippo

I want to construct a report with the top 4 values from a table

how i could resolve the problem?
 
Reports are based on tables and queries. Create a query and change the
property to allow only the Top 4 values. (you'll need to decide on what
basis the rows get sorted before deciding which are the "top 4").

Regards

Jeff Boyce
<Access MVP>
 
Jeff Boyce said:
Reports are based on tables and queries. Create a query and change the
property to allow only the Top 4 values. (you'll need to decide on what
basis the rows get sorted before deciding which are the "top 4").

Regards

Jeff Boyce
<Access MVP>
Click to expand...
I explain better my problem


I want to construct a report with the top 4 values from a table

If the structure of the table is:

IDTAb Field

01 123
02 222
03 444
04 555
05 456
06 999

the result report that i would want is:

field1: 123
field2: 222
field3: 444
field4: 555



how i could resolve the problem?
 
I'm afraid I'm not following.

If you have only two fields (in your example, named "IDTab" and "Field"),
how can you have "Field1", "Field2", etc.?

And you and I might not have the same definition of "Top".

Are you asking for the smallest 4 values or the largest?

Jeff Boyce
<Access MVP>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access count a field in access report 2
HOW CAN I COUNT ALL THE GROUPS IN A REPORT 1
Enabling Users to Filter Report Results 6
vba code help for multiple string searching 0
Scrabble Value calculation for Welsh words 0
2 out of 3 fields won't grow on report 4
Create a report based on information from two forms 2
Sum Top Values 2

Back
Top