Filling in data to the selected field

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

Hi everyone,

Initially I can work with the code below...
But I want some modifications.

Below is the output I want...J0001(OLD) WHILE J0002 (NEW)

Before :-
Bil (pk) JobNumber PartNumber RequiredQty
KittedQty
1 J0001 A1 1
1
2. J0001 B1 8
6
3. J0002 B1 8


After:-
Bil (pk) JobNumber PartNumber RequiredQty
KittedQty
1 J0001 A1 1
1
2. J0001 B1 8
6
3. J0002 B1 8
6

So, basically I just want to copy the KittedQty from the old to the new job
of kitted quantity if there is same partnumber exists in both job number...

In this case, I want to copy the kitted qty for PartNumber B1 (J0001) TO
JobNumberNew(J0002) TO Kitted Qty
and ignoring the A1....
Note: All of this data involve only 1 table

Code:
 
EMILYTAN said:
Hi everyone,

Initially I can work with the code below...
But I want some modifications.

Below is the output I want...J0001(OLD) WHILE J0002 (NEW)

Before :-
Bil (pk) JobNumber PartNumber RequiredQty KittedQty

1 J0001 A1 1 1

2. J0001 B1 8 6

3. J0002 B1 8

After:-
Bil (pk) JobNumber PartNumber RequiredQty KittedQty
Click to expand...
1 J0001 A1 1 1

2. J0001 B1 8 6
Click to expand...
3. J0002 B1 8 (6)
Click to expand...
So, basically I just want to copy the KittedQty from the old to the new job
of kitted quantity if there is same partnumber exists in both job number...

In this case, I want to copy the kitted qty for PartNumber B1 (J0001) TO
JobNumberNew(J0002) TO Kitted Qty
and ignoring the A1....
Note: All of this data involve only 1 table

Code: 
[/QUOTE]
Click to expand...
 
Back
Top