Autopopulate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 5000 records and one field has to have the same
information added to every record. How can I do that quickly? I tried to
select the column and paste but that does not work.

Thanks,
 
Do an update query. Add your table to the query, pull down the field you
need and on the Update To row, add the data needed.

Hope this helps.

Jackie
 
Thank you so much. That was so much easier. It took 1 second versus hours.

Thanks again!
 
Debra said:
I have a table with 5000 records and one field has to have the same
information added to every record. How can I do that quickly? I
tried to select the column and paste but that does not work.

Thanks,
Click to expand...

Sounds like you should not be doing that! If the data is the same for
every record, you should not be saving it to a table. This is not a spread
sheet. Access is a database.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autopopulate text box based on an unbound combo box 4
Make a Date Field Autopopulate 6
autopopulate fk 4
pop up form to open one record with dlookup 1
Autopopulate a form 7
Create default text based on another text field 1
Design Question 1
Change text box to populate a new sequenced number 4

Back
Top