Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: workerbee777
- Order by date
-
Create autonumber field in make table query
Bob, You're right, it would be fairly easy to identify the latest treatment. And, in a perfect world, the tables would be normalized. However, I need to manipulate this data in other queries, etc. Since I'm stuck with this setup... What I have been doing is sorting by client, then treatment...- workerbee777
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Create autonumber field in make table query
Bob, Thanks for the idea. I will look for that other thread--I searched long and hard before I posted my question. The only reason I'm using Autonumber is to assign a sequential order to the records in a table becuase the table is not well normalized. I can have several clients with multiple...- workerbee777
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Create autonumber field in make table query
So, we've discussed how to make a new table with an autonumber field using only SQL statements. However, I need to make a new table with a new autonumber field using a make table query (and referencing data in multiple linked tables). I have heard of doing this by referencing the record number...- workerbee777
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
