Is there another way to make a column in a table the primary key if you already assigned it to the autonumber column? I would like to make either the student id or the social security number the primary key.
djbsabkcb 0 Junior Poster in Training
Edward Kinlen 0 Newbie Poster
As long as the table is correctly broken down ;) to allow only one SSN per line in the table. If it is storing that information more than once you can't use the SSN as the primary key. Elaborate more about how you have your :rolleyes: table assembled.
spycee 0 Newbie Poster
I would like to have 3 tables, in a query I would like to add them together to have a total from Table 1, 2 and 3.
In the last feild I would like it to show the total insead it only shows all the numbers
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.