Transfer data from query into table

[Guest]

i have a table named customers which holds all my customer info.

I have a query which calculates the customerID from the customers last name
and first name. CustomerID: [Customers]![Last Name] & ", " &
[Customers]![First Name]

All works fine, but i want the query to transfer the customerID back into my
table named customers under the customerID field.

 

[Guest]

I would not recommend that you store a calculated field back into your table.
In fact, you rarely want to store calculated values in any table.

Using First and Last names as an ID are usally avoided. What whould you do
if you have two John Smiths? Your ID would be the same. Secondly, you are
taking up unncessary space (and losing speed) by storing the same data twice.
Data normalization is one of the primary jobs of the database designer.
Third, if someone changes their nams (i.e., gets married) you have to look
for those changes and deal with it.

If you could add more to what you are trying to accomplish perhaps someone
could provide better help.

Having given you proper warning, to add values into a table from a query you
use an UPDATE query or statement.

If you use the the Access query builder, copy your existing query and give
it a name, like qupd_UpdateNames, and change the query type to update.
Access has a pretty good guide on how to do this in the help section.

Let me know if this helps.

Randy