I am new to this forum and reletively new to Access as well, please by patient.
I am attempting to display a field called "DueDates" based off of data located in another Field called "CourseCompletionDates", I know how to advance every record by a determined amount but what I am trying to due is have it advance the date for some records by one year, others by two years, etc. The unique identifier is the field called "CourseID". Any help would be appreciated.
I am attempting to display a field called "DueDates" based off of data located in another Field called "CourseCompletionDates", I know how to advance every record by a determined amount but what I am trying to due is have it advance the date for some records by one year, others by two years, etc. The unique identifier is the field called "CourseID". Any help would be appreciated.