title: Access: Updating multiple rows with different values
body: <p>I have a table describing calls made with the company cellphones, one of the fields is callTypeId, every call has one, while other is callType, a text description of the ID. Several calls lack a text description so what I want to do is to update each record with a description matching its callTypeID.</p>
  
  <p>The number of different Id's is low, 15 but some Id's are for the same type of call (5 Id's for local calls for example). There are over 15,000 records so I'd like to know what is the best way of doing so.</p>