Sorting Top Three Values

[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!


--

 

[Dennis]

Sort your query by Batch - Descending and then put a number 3 in the "All"
text box on the query menu bar.

 

[Marshall Barton]

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

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