Updating an Access Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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).
Click to expand...

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? )
Click to expand...

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)
Click to expand...

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]
 
Back
Top