Jun 25 2008, 11:08 PM
I want to update the null fields in each row to the same address data as the one populated row of data. I was trying to do a SELF-JOIN by the site id field but it is not working. So, each row will have the same name, address, city, etc. They are not duplicate rows because they contain other fields which make them unique to each other except by address data. Unfortunately, these rows were added without the address data and need the all the fields populated.
SITE_ID LOC_ID NAME STREET1 CITY STATE_CODE ZIP RECORD ID
150298 288512127 1
150298 288512127 2
150298 288512127 3
150298 288512127 BROWN TREE SERVICE 111 BROWN ST BROWN TN 768590000 4
Jun 25 2008, 11:13 PM
Before I suggest something here, Update query etc, could you pse attach the DB so I can get a better picture.
Jun 25 2008, 11:17 PM
This database is huge, but the problem is contained within just one table. I am just trying to update the null fields so I don't have to copy and paste the data into each one.
Jun 26 2008, 01:48 PM
Without seeing your tables and relationship with other tables all I can suggest is using an update query. Of course, somehow you are going to have to work out a self-join or inner-join.
Sometimes this sort of update can be accomplished using VB code - I tend more to the code because sometimes you can get a better result.
I'm sorry I can't provide more help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here