Default Values
in [Tables]
|
From: Andy Roberts on 20 Jun 2008 15:39 I want to add a field to an existing table which has a default value. The table already has thousands of records and the default only gets applied to new records. How do I automatically apply the default value to all existing records? -- Regards Andy ___________ Andy Roberts Win XP Pro Access 2007
From: Mark on 20 Jun 2008 16:33 You can use an update query and update the new field in all existing records to the desired value. Steve "Andy Roberts" <andy(a)blue-bean.co.uk> wrote in message news:zfGdnS9oMKrFmsHVnZ2dnUVZ8rOdnZ2d(a)bt.com... >I want to add a field to an existing table which has a default value. The >table already has thousands of records and the default only gets applied to >new records. How do I automatically apply the default value to all >existing records? > > -- > Regards > > Andy > ___________ > Andy Roberts > Win XP Pro > Access 2007 >
From: Andy Roberts on 20 Jun 2008 17:11 Mark Perfect. All done. Thanks -- Regards Andy ___________ Andy Roberts Win XP Pro Access 2007 "Mark" <notmy(a)email.com> wrote in message news:-cednbNbioWlicHVnZ2dnUVZ_vSdnZ2d(a)earthlink.com... > You can use an update query and update the new field in all existing > records to the desired value. > > Steve > > > > "Andy Roberts" <andy(a)blue-bean.co.uk> wrote in message > news:zfGdnS9oMKrFmsHVnZ2dnUVZ8rOdnZ2d(a)bt.com... >>I want to add a field to an existing table which has a default value. The >>table already has thousands of records and the default only gets applied >>to new records. How do I automatically apply the default value to all >>existing records? >> >> -- >> Regards >> >> Andy >> ___________ >> Andy Roberts >> Win XP Pro >> Access 2007 >> > >
|
Pages: 1 Prev: 2003 problems Next: Field type txt or nos for relating to autonumber field ? |