Update Column in original table -------M------

  • Thread starter Thread starter Mark909
  • Start date Start date
M

Mark909

Hello,

I need to update a single column in a table containing 20000 records.

I need to update every record in the column with the number 1.

Im sure its not too hard but i cant seem to find how to do it.

Thanks!
 
Mark909 said:
Hello,

I need to update a single column in a table containing 20000 records.

I need to update every record in the column with the number 1.

Im sure its not too hard but i cant seem to find how to do it.

Thanks!
Click to expand...


If I understand correctly, that you want to assign the value 1 to a specific
column in every record ...

CurrentDb.Execute "UPDATE YourTableNameHere SET YourColumnNameHere = 1"

This assumes the column is a numeric column. If it was a text column you'd
need quotes around the value being assigned ...

CurrentDb.Execute "UPDATE YourTableNameHere SET YourColumnNameHere = '1'"
 
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

Access Dcount (multiple criteria) 3
Turning a 3 column flat file into a "3D" Table 2
Create New Table/Column 1
Sequential numbering when X column repeats records 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Add a running total field to a query containing only 1 table 1
How to replace a null column value in a fixed length text file 1

Back
Top