Can i add field autonumber-counter to this query (> table tblresult) ?

start table tblmaster id, field0
qrytest1 > tblmaster
qrytest2 > tblmaster
now tblresult field1, field2

SELECT qrytest1.field1, qrytest2.field2 INTO tblresult
FROM qrytest1 INNER JOIN qrytest2 ON qrytest1.ID+1=qrytest2.ID;

thx

there is no way to specify an autonumber field in a query -- but you can change the table after the query makes it ...

why are you making a table anyway?

The autonumber need me only in table.
It need for other query.
The original table has many other records that do not serve to me.

regards

I do not understand

there is most likely no reason to make a table if you are just wanting certain records... what are you doing?

In master table have a a syntax like <Time>2005-07-17T05:05:47Z</Time>, with the query extract time , create table, and then make calculation.
it's a little difficult to explain...

if you can't explain it, no one will be able to help you ...

Here is a post with information on setting up data efficiently.

A new guy figuring out how to search -- discussion on normalizing data, designing tables and forms

about halfway through the post, there is a lengthy discussion on data structure, naming, etc ... and about 1/3 from the end is instructions for documenting the relationships and table structures

here is a link that I got from Noah's signature -- looks pretty good for some basics:

Access Basics