add one autonumber field on union query

[polyubi]

hello every body.
I want to add one column of autonumber on my union query, is it possible? Can anyone give me a thread? or example?

 

[PNGBill]

hello every body.
I want to add one column of autonumber on my union query, is it possible? Can anyone give me a thread? or example?

You may mean add one Field to a Union Query.

There are no columns in this part of your data base. You have columns in reports from a layout point of view.

What is your Union Query doing??

If it is Appending a record to a table then leave out the field with the autonumber from your query as the table will populate this for you.

 

[polyubi]

thanks for reply in such a late noght
I have a "select.......union all select..........." query. I want to add a field, an ordinal number in this query.

 

[PNGBill]

What will you do with this number?

I don't think it is very easy to have a query return such a value for each record as a spreadsheet can do.

But, you can have your numbers in the output of your query.
ie, If you are running a report, then add a Running Sum control to your report.

If you Create a Table (could be Temporary) or append data to a table then you can have the table provide the numbers.

If you want the count of records then a query can return this.

Maybe one of the more experienced forum members will have better advice.