June 7, 201015 yr Hello, I have a student database, in which i have already entered all records.I created a semester field later.Now, i want this field to carry a default value of "spring".What i did is that in the options section for fields i entered the default value in auto-enter tab.But, this works only if i create a new record(that is , it enters the default value for all new records) and not the already created ones.Is there a way that for these already existing records also the default value gets entered.I am asking because no.of already existing records is 700!! and i dont want to enter manually. Any help will be appreciated Thanks, sunshine3 Edited June 7, 201015 yr by Guest
June 7, 201015 yr Hi Sunshine3, You need to place the value in those records yourself. Back up first then find all records with no value by searching for = in the field. Place your cursor in the field and type Spring. The select Records > Replace Field Contents and first radio button will say, "Replace with Spring." Below, click the Replace button. :wink2:
Create an account or sign in to comment