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>
 
Back
Top