Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you have a field within a query that is an autonumber? Like when you set
up a table.
 
It's hard to answer your question without knowing the table structure that
the query is base on.
Incase there is a field that you can sort by, and that field doesn't repeat
itself (apear only once in the query) you can use something like

SELECT (SELECT Count(*) FROM TableName As C where C.FieldName
<=TableName.FieldName ) AS RecordNum, TableName .*
FROM TableName
ORDER BY TableName.FieldName

Note:
FieldName = Unique value within the query
 
Thanks for that. The problem I have is that the query I'm trying to put the
Autonumber into works off another query, which works off another query etc
etc. I know that if it's working off a table I can do it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Links in Query results 3
Create table query... want to insert autonumber column 3
Make Table Query and Autonumber Fields 6
Trouble with Query Results 11
Append query - Append to table with Autonumber field 2
Append to table with 2 fields in Primary Key - last is an autonumb 1
query that brings a autonumber field 6
Update the values in a table from another table 1

Back
Top