Update Data Based on plat number and Date

[sandy70]

hi all

I got some problem for updating data from 2 table

I have 2 tabel : Data01 and Data02



I like to update CV in Data01 based on Data02

The result i am lookin for



no 1 > the new CV will be CV Jasa Unggul Prima coz the 31 jan 24 is in between 05 jan and 11 Mar
no 2 and 3 > the CV stay the same coz nothing change from 12 Mar untill now

anyone can help ??

 

[Pat Hartman]

Is this a one-time effort to clean up bad data? There is no unique join available to you between the two tables, plus the tables contain duplicates so how do you know which row to update with the new value?

We need to know more details to give you better advice. What you have now simply doesn't work. Give us an overview of the current process and tell us how the data got out of sync and why the data is in two tables now.

 

[sandy70]

Is this a one-time effort to clean up bad data? There is no unique join available to you between the two tables, plus the tables contain duplicates so how do you know which row to update with the new value?

We need to know more details to give you better advice. What you have now simply doesn't work. Give us an overview of the current process and tell us how the data got out of sync and why the data is in two tables now.

so here i got 2 Invoicing data from a company with some sub contractor

every couple day the truck ( BM ) moving around from one sub contractor to another sub contractor ( CV )



for example BM 8901 QU
01 jan at CV Mega then 10 Jan moving to Global

the problem is some ( around 1000++ ) invoicing data ( CV ) are wrong ( Data01 )

how can i fix it ???

 

[arnelgp]

i backup Data01 table.
see if qryUpdateCV will do the job for you.

 

[sandy70]

i backup Data01 table.
see if qryUpdateCV will do the job for you.

tq , i am gonna cek it now

 

[sandy70]

qryUpdateCV run correctly

tq so much for helping

you save my day from manual edit

 

[Pat Hartman]

qryUpdateCV run correctly

When there are duplicates in both tables, MAKE SURE that each record got updated to the correct value.

 

[sandy70]

When there are duplicates in both tables, MAKE SURE that each record got updated to the correct value.

tq for remind me about that
i do random cek only , need more time to cek all the data

but i gonna cek that later