scan records in table

N

NYC Rag

In paradox you can scan each record in a table and make changes to the data
based on condition or data in the table. Sometimes a query just dont cut it

How do you do this in Access ?
 
D

Dirk Goldgar

NYC Rag said:
In paradox you can scan each record in a table and make changes to
the data based on condition or data in the table. Sometimes a query
just dont cut it

How do you do this in Access ?
Click to expand...

I'm not familiar with Paradox, so I don't know how the feature you
describe works. In Access, you can of course open a table in datasheet
view, and you can filter that view on conditions you specify, and
manually change records that meet the filter criteria. I don't know if
this is the sort of thing you're talking about or not. Or you can build
a query, make sure it returns the records you want, and then turn it
into an update query to update them.
 
J

John Spencer (MVP)

You can open a recordset in vba and step through the records one by one.
 
Top