updating field with same value

[hnunez4399]

I hope someone could help me. I have a talbe that i am importing from Excel. I want to updated a column with the total units for each record that is imported into access, with the same value. How or what would be the easist way to accomplish this?

Example table

sku# total Units Count of SKUS
A


I a query that currently runs to add the total units for all SKUS on the table Above. I want the Total units field to now get updated with this number for all records in the table above.

thanks

 

[mhartman1]

Hello:

What you want to do is run an "Update Query"

Regards
Mark