Sorting Top Three Values

  • Thread starter Thread starter LV
  • Start date Start date
L

LV

I have a query that lists out data in numerical order...

I have a column called "Batch" and it contains over 4000 values (1-4000).

What criteria can I enter so I only see the top 3 Batch values (i.e. only
Batches numbered 3997-4000)?

I also need this to auto-update, so when I enter in Batch 4001 it will
display the top 3 batches as 3998-4001

Thanks!


--
 
Sort your query by Batch - Descending and then put a number 3 in the "All"
text box on the query menu bar.
 
LV said:
I have a query that lists out data in numerical order...

I have a column called "Batch" and it contains over 4000 values (1-4000).

What criteria can I enter so I only see the top 3 Batch values (i.e. only
Batches numbered 3997-4000)?

I also need this to auto-update, so when I enter in Batch 4001 it will
display the top 3 batches as 3998-4001
Click to expand...


Set the query's Top Values prpoperty to 3 and sort
Descending on the batch field.
 
Back
Top