Database Operations – Concatenate And Update Fields

I receive a weekly Access database file with CE Credit information from multiple crediting agencies.

These credit information text fields ([required language] field) must be merged together for each particular course type, and then stored as a memo field in a separate table. The id number of that record must then be stored for the records in a separate table containing date/location information for a particular class.

The end result can be described as follows.

A site visitor sees a cla…

Leave a Reply

Your email address will not be published. Required fields are marked *