Easy Table Population Question

[novicius]

Hello!

My mind is a complete blank on this one and I *know* the answer is easy:

In Access XP, I have a 50,000+ record Customer table with all the standard contact fields except "State". How would I craft an Action Query (no code please) to populate the value 'WI' for each record after adding the "State" field?

Bah, kick me now -- and thanks in advance!!

- novicius -

 

[M8KWR]

use an update query.

Create the field (state).

Then create a new query, insert your customer table, then drag down the state field.

Change the query to an update one. THen type WI in the update select underneath the state field.

Then run the query.

That will update all records for you.

Hope that is what you wanted...

 

[novicius]

That is *exactly* what I wanted and it worked like a charm!

Thank you and case closed!

- novicius -