Numbering Lines in a query?

[Guest]

I have a set of data that I need to number 1,2,3 Etc. Each time I run the
query.
Let me know if this is possible.

Thanks in advance

 

[Douglas J Steele]

For what purpose? If it's for a report, reports have that ability built into
them. If for something else, some more details might be useful.

 

[Guest]

I need to append the query into a table.

 

[Douglas J. Steele]

As I said, we'll need more details. What do the tables that the query's
based on look like?

 

[Guest]

I have a fields in the table.
Vendor-Text Format
The vendor field can have any where from 1 to 60 Vendors.
The Append query is a group by vendor.
I need to append it to a new table with the Vendor and a number field 1,2,3
etc appending to the number field.
I need to number the vendors each time I run the query back to 1,2,3.
I will delete the data out before I run the query again
I tried to use the auto number but that doesn't start back at 1.

 

[Guest]

Your auto number is still the best bet. Yes if you use the same table is will
increment 61 and so on.

Rename the old table VendorOld. Copy and paste the table, choose the
structure only choice back to the original table name. Then the ID will start
from 1 again. A new table starts at 1. The old table starts where it left
off.

You may need to rethink your database structure. This does not seem to be an
ideal solution to your problem. The power of a auto number ID system is the
fact that each record is unique and consistent. Properly set up you will not
introduce duplicates which is critical to an accounting system or a database.
We have a similar delima in a one time payee system. Use it once then start
over again.

If you use the same vendors but assign them different numbers, for example,
Vendor 1 is USA one period, 3 the next and 55 another. You can't have a
relational database that works with you invoices over time. There are places
for this simple one-use type of processes, however, for a Vendor and Claim
database this is not a good database choice.