Entering 'mass' data in an Access Table 2

[slmanning]

Does anyone know if it is possible to enter data in 'mass' in an Access Table? For example, I have a column that is a yes/no check box, can I select numerous records and check the box in all of them at once?

 

[Bell1991]

Are you familar with SQL? IF so, you can write an update statement - pending all the records you want to update have something in common.

For example, if you have a table called tblTest with the following columns:

numID number ,
txtName text ,
txtAddress text ,
txtCity text ,
txtState text ,
txtZipCode text

And you wanted to update all txtState to = NY

update tblTest
set txtState = "NY"

if you wanted all records where the state name = "NY" then
update tblTest
set txtCity = "test city"
where txtState = "NY"


hope this helps

 

[MoLaker]

Not exactly like you are thinking. But, you can use an update query.