Updating an Access Form

[Guest]

I have a table with roughly 2000 customers. Is it possible to update this
table if, say, 60 customers have a change with their information (different
credit limit/new company name so forth).

(In Excel, you can do a Vlookup that allows you to type in a formula so that
every cell will change according to that formula. Is there something liek
this in Access or is it better to stick with Excel? )

Thanks for any type of help. (Dlookups only helped do a filter type search
to updatte one at a time)

 

[Guest]

Have you tried an update query with criteria?

Brad

 

[John Vinson]

I have a table with roughly 2000 customers. Is it possible to update this
table if, say, 60 customers have a change with their information (different
credit limit/new company name so forth).

Of course. How do you determine which customers need changes? Are you
doing the changes one at a time or can you provide criteria to select
all sixty in one go.

(In Excel, you can do a Vlookup that allows you to type in a formula so that
every cell will change according to that formula. Is there something liek
this in Access or is it better to stick with Excel? )

Access is Access. Excel is Excel. THEY ARE DIFFERENT. Learn to use
Queries - they are the bedrock of Access.

Thanks for any type of help. (Dlookups only helped do a filter type search
to updatte one at a time)

Since we know nothing about the structure of your tables, or how the
records to be updated should be identified, all we can suggest is "use
an Update query with appropriate criteria".

John W. Vinson[MVP]