Update Query Help

[Tasar]

Im really new to Access and I've been asked to figure this out. I have
two tables. One of a mass of data that have no postal codes in the
postal code coloum. I have a second table with a list of deralers and
their address. How to I replace the empty cells with the match dealer
names and their postal codes?
Remember, Im damn new to Access, it'll pretty much need to be spelled
out for me.

 

[Larry Linson]

What fields determine which records to match? "Mass of data" doesn't tell us
very much. If you can determine which fields (Access doesn't use the term
"cells") should be used, and which fields from the table listing dealers
should go into which fields in the table "mass of data", perhaps someone
could suggest how you would create an update query to do what you want.

It's unlikely, however, that a "postal code" column would be formatted so as
to hold both the dealer name and the postal code.

There are good suggestions on effective use of newsgroups in the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP

 

[Joseph Meehan]

Im really new to Access and I've been asked to figure this out. I have
two tables. One of a mass of data that have no postal codes in the
postal code coloum. I have a second table with a list of deralers and
their address. How to I replace the empty cells with the match dealer
names and their postal codes?
Remember, Im damn new to Access, it'll pretty much need to be spelled
out for me.

In addition to Larry's comments, I might suggest that you may not want
to add those postal codes to your first table. Access is a relational
database. It likes to look up data in related tables. So what you want to
do is to have it look up the code any time you need it, not add it to an
existing table.

Adding it to an existing table is likely to cause errors when someone
moves or the code changes and you forget to change all the instances of it
in other tables.