Update Query

[Joe Gieder]

Thank you for the help.
I posted this under the original Make Table thread also
but not sure if it should go there.

I have another question now. After I created the table
with the fields required I want to join two tables
together and update the new table with informaition from
the old table. What I have is two fields one called
Material and the other Plant. Each record under Material
may contain a duplicated material number but a different
plant location, what I'm trying to do is have only one
occurance of the material number (I did this with a
groupby) and update each of the new fields with an "X" if
the material exists at that plant (there are 17 different
plant locations so i created 17 fields, some material is
in only one plant but others may be in all 17). I tried
to do an update query by adding all 17 plants to the
fields and then in the criteria for each different plant
saying [marcmay404]![plant]="ac01", [marcmay404]![plant]
="ac02" respectively and so on for all 17 but it came
back saying 0 records to update (I have 265,000 records).
Can this be done all at one time or do I need to do it
one field at a time?

Thanks again
Joe

 

[Les]

Just posted under your original. Hope it helps.