Update

[subs]

customer dzip New Customer
proctoandg 10024 procto
procto 10024 procto
procto 10024 procto
bambo 13456 bambospecies
bambospecies 13456 bambospecies
barbs 200011 barbs
bangal 10022 bangal

I have two columsn of data which are populated. customer and dzip.
The column New customer has to be populated such that new
customer has to be equal to column customer when
ever they have equal dzips. for example the first two entries
in the new colum are procto since they have equal dzips. Now this
could be populated by either proctoandg or procto- but procto is
repeated more no
of
times in my original data than proctoandg . So new customer field will
have
procto in the
first two fields.

So bottomline

new customer colmn is populated
by using two crieteria


1)Dzip field values must be equl
2) when ever dzip field are same, then populate the last
colum
with the value of the column customer which is repeated max no of
times. \\

Thanks for any help . help is appreciated.

 

[Jeff Boyce]

How many of these do you need to update? Are you looking at thousands of
entries, or a few hundred?

How often will you need to do this update? Are you fixing data one time or
working on a routine to update the 'bad data' once a day?

If small numbers of records and once are your answers, you'll spend
considerably less time doing it "by hand" (USB techonology - using someone's
brain) than creating and testing an automated procedure...

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

 

[subs]

How many of these do you need to update?  Are you looking at thousands of
entries, or a few hundred?

How often will you need to do this update?  Are you fixing data one time or
working on a routine to update the 'bad data' once a day?

If small numbers of records and once are your answers, you'll spend
considerably less time doing it "by hand" (USB techonology - using someone's
brain) than creating and testing an automated procedure...

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP











- Show quoted text -

This is once in a while and has 30000 records. So is there a query
that i can use to update it ( just for now) i need to do the update
immediately

 

[Jeff Boyce]

That sounds like a good candidate for a routine you can run as needed.

Unfortunately, I've never run across such a conversion/update situation, and
am having trouble imagining how I would approach it. Hopefully one of the
other newsgroup readers can offer some insight.

Let me try one other idea ... if you were going to explain how to do this
update/conversion to a part-time worker, how would you explain how to decide
when to use which version? It may be that in spelling out the steps
involved you can see a way to automate those steps.

For instance, it sounds like you first need to identify all the duplicates
(that is, rows for which the ID matches). You can do that (single) step
using the query wizard and a "duplicates" query.

Once you have those identified, then you need some way to identify which
versions of the code happen most frequently. This is the part that's
confusing me, as you seem to be looking at each character, rather than all
as a unit.

Here's a totally off-the-wall idea ... since you'll be changing the codes
anyway, and in some instances, to values no one has ever seen, what about
the idea of simply not using ANY of the old code/code fragments, and just
inventing new codes?

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

How many of these do you need to update? Are you looking at thousands of
entries, or a few hundred?

How often will you need to do this update? Are you fixing data one time or
working on a routine to update the 'bad data' once a day?

If small numbers of records and once are your answers, you'll spend
considerably less time doing it "by hand" (USB techonology - using
someone's
brain) than creating and testing an automated procedure...

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP











- Show quoted text -

This is once in a while and has 30000 records. So is there a query
that i can use to update it ( just for now) i need to do the update
immediately