Jul 21 2005, 02:02 AM
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;
Jul 21 2005, 02:41 AM
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?
Jul 21 2005, 02:51 AM
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.
Jul 21 2005, 02:54 AM
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?
Jul 21 2005, 03:02 AM
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...
Jul 21 2005, 10:54 AM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here