I have a quick question regarding creating a recdordset programmatically in Access 2000. I’ve been asked to generate a rollover function for existing records. The problem arises if the user creates a rollover (copying the current years recordset and adding a year to each date field). There may not be a complete recordset to work with. For example, each client has a Valuation that corresponds to Quarterly, Semi-Annual, and Annual. If only 2 of the quarterly records were entered, the rollover will only create 2 records for the new year. I need the new rollover function to read the base client info, check to see if it’s Q, S-A, Or A, then create the appropriate number of records for the new year. Any ideas as to how this can be accomplished?
