Update Querry

[Daryl2106]

Hi Everyone,



I am trying to update a table that has been offline for a bit with a table that was being used. They contain exactly the same fields and datatypes. I assume there is a way to update all fields at once. (This is a Student Information Table so it has about 24 fields.) Can anyone show me what the SQL would look like for this (just beginning to use SQL over "Design View"). I'm using MS Access 2010 and the two tables are ContactInformation (existing and to be updated) and ContactInformation1 (containing new info for some records).

Thanks and take care,

Daryl

[June7]

Do you need to update existing records or add new records or both?

Do these tables have autonumber field?

Are the fields in the table in the same order when viewed in design?

[Daryl2106]

Hi,

Thanks for the reply. I only need to update existing records. The PK is autonumbered in both tables. The fields in the table are in the same order. They are identical in evryway except some filed may have had the data changed.

Take care,

Daryl

[June7]

If the PK is autonumber in both tables, then what would be the unique ID that will link records?

[Daryl2106]

Hi JUne,

Ooops. The PK is not an autonumber field. I used StudentID as the PK and it is a text field. This was very early in building the DB and there may be some inherent difiiculties with this. I think my rationale was that some StudentIDs began with zeros (0001234) and the number data type would truncate the zeros.Not really an issue but I think I went with text to keep the format the same.

So it is the StudentID field which links the two tables. Each StudentID is enter by the user as a new student is enrolled.

Thanks agian,

Daryl

[June7]

The records are unique for each student - only one record for each student?

See if this helps http://www.ehow.com/how_7494463_upda...her-table.html

[Daryl2106]

Thanks June. That was helpful.