Adam
You have a mistaken assumption. Autonumbers are intended for use as
unique
row identifiers. There's no inherent need for them to be sequential.
If you already have a [Amt] field you can sort descending by amount, then
why not just use that? If you need only the top 20, you can use the Top
property of a query to return only the top ... 20?!
Regards
Jeff Boyce
Microsoft Office/Access MVP
Adam said:
The data that I will be supplying in this new table will be sorted in a
high
dollar order. I am trying to pull out the top 20 dollar amounts out of
another table. My theory is: if I query Table 1 and sort -descending,
then
post to a new table and apply an autonumber, the autonumber will serve
as
a
rank. Then I can query this table and filter out all ranks <21. A
report
based on this query can display the Top 20. If there is an easier way,
I
am
all ears.
:
Adam
Perhaps you and I don't share the same definition of "rank". To me,
this
term implies some inherent order.
Is this how you use the term?
What will having a "rank" for each record allow you to do that you
couldn't
otherwise do?
Regards
Jeff Boyce
Microsoft Office/Access MVP
I am trying to post new data to a table every week and apply an
autonumber
to
rank the data. How can I apply an autonumber to the new data after
my
delete
query has cleared out the previous data? Automatically, of course.
I
would
like my macro to be able to delete and post the new data by rank, so
that
reports can be generated as well.
