P
pippo
I want to construct a report with the top 4 values from a table
how i could resolve the problem?
how i could resolve the problem?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
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>
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>
P
pippo
I explain better my problemJeff 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>
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?
J
Jeff Boyce
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>
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>