Hi
I kneed to know a way in which to create Auto-numbers within a query. (I can not use the Auto-numbers in the tables).
For example. I have a query wich selects certain data from a table:-
Query1
Field1 Field2
SERVER1
SERVER2
SERVER3
SERVER4
As you can see there is no data in Field2, I want it to be populated with autonumbers from the information in Field1
Field1 Field2
SERVER1 1
SERVER2 2
SERVER3 3
SERVER4 4
Now I kneed Query2 so that it displays information and creates autonumbers aswell but this time I want the autonumbers to start using the last number used in Query1
Query2
Field1 Field2
GROUP 5
HOME 6
DATA 7
EMAIL 8
Regards
Djbell
I kneed to know a way in which to create Auto-numbers within a query. (I can not use the Auto-numbers in the tables).
For example. I have a query wich selects certain data from a table:-
Query1
Field1 Field2
SERVER1
SERVER2
SERVER3
SERVER4
As you can see there is no data in Field2, I want it to be populated with autonumbers from the information in Field1
Field1 Field2
SERVER1 1
SERVER2 2
SERVER3 3
SERVER4 4
Now I kneed Query2 so that it displays information and creates autonumbers aswell but this time I want the autonumbers to start using the last number used in Query1
Query2
Field1 Field2
GROUP 5
HOME 6
DATA 7
EMAIL 8
Regards
Djbell