dbTalk Databases Forums  

Filling data fields automatically

comp.database.ms-access comp.database.ms-access


Discuss Filling data fields automatically in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sean Ryan
 
Posts: n/a

Default Filling data fields automatically - 07-08-2003 , 01:58 AM






Is there an easy way, in a simple Access table with a lot of records, to
populate the same field of every record with the same peice of data? for
example, to put the same number, 1314, in the selected field of each record,
without manually entering it repetitively?



Reply With Quote
  #2  
Old   
Ray
 
Posts: n/a

Default Re: Filling data fields automatically - 07-08-2003 , 07:53 AM






"Sean Ryan" <smryan (AT) worldnet (DOT) att.net> wrote

Quote:
Is there an easy way, in a simple Access table with a lot of records, to
populate the same field of every record with the same peice of data? for
example, to put the same number, 1314, in the selected field of each record,
without manually entering it repetitively?

Hello,

Perhaps you can look into update queries in the Help. Change records
as a group is an example.

Ray.


Reply With Quote
  #3  
Old   
John
 
Posts: n/a

Default Re: Filling data fields automatically - 07-08-2003 , 11:57 AM



All you have to do is create an update query. Start a new query and
select the table that you are working with. Click on Query | Update
Query. Now bring down the field that you want to update in the Field
list. In the Update To field type in the number that you want to
display in all the fields (in your example, 1314). Now run the query
by clicking on Query | Run.

"Sean Ryan" <smryan (AT) worldnet (DOT) att.net> wrote

Quote:
Is there an easy way, in a simple Access table with a lot of records, to
populate the same field of every record with the same peice of data? for
example, to put the same number, 1314, in the selected field of each record,
without manually entering it repetitively?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.