row numbers for this distinct query

  • Thread starter Thread starter adgorn
  • Start date Start date
A

adgorn

I'd like to add row numbers to this query, which I got from the sql view
after using design view:

SELECT DISTINCT [0 client codes].input, [0 client codes].[iDonation
Category], [0 client codes].[iDIV 1], [0 client codes].[iDIV 2]
FROM [0 client codes];

Can't figure out how???
 
Make a new query. Go to sql view. Type:
Alter table yourtablename
add column id counter(1000,1) (or whatever numbers you want)
Turn the query into a make-table query (query/make-table) run it. It will
add the number column to your table.
 
I'd like to avoid a make table operation if possible because this query is
also the source for another subsequent query.
--
Alan


Golfinray said:
Make a new query. Go to sql view. Type:
Alter table yourtablename
add column id counter(1000,1) (or whatever numbers you want)
Turn the query into a make-table query (query/make-table) run it. It will
add the number column to your table.

adgorn said:
I'd like to add row numbers to this query, which I got from the sql view
after using design view:

SELECT DISTINCT [0 client codes].input, [0 client codes].[iDonation
Category], [0 client codes].[iDIV 1], [0 client codes].[iDIV 2]
FROM [0 client codes];

Can't figure out how???
Click to expand...
Click to expand...
 
Back
Top