Updating Records

[gary.newport]

I have two tables; one are existing student records and the other contains imported student details. The system already adds new students to the existing records, marks missing students as left but now I have a situation where I need to update records where students have simply had a change of detail (or new details have been added).

Do I need to create an update query for each and every possible change (considering there are about 10 fields that could change I would rather not have to do that!) or is there a way to create a query that would update those fields that have changed and ignore those that have not?

 

[namliam]

Updating fields that have not changed will not hurt will it??

Simply make one update query and update all that need updating.

 

[gary.newport]

I agree but I was concerned over the time it could take. However, querying each field would also be lengthy, if not more time consuming so, yes, I will update all fields.

Thanks. )