I
ibo
Hi all
I have to concatenate serial number according to part number and Coc No
Part Number Description Qty CoC No Serial Number
H-32-0512-50 PIN 1 1 1
H-32-0512-50 PIN 1 1 2
H-32-0512-50 PIN 1 1 3
H-32-0512-50 PIN 1 2 5
H-32-0512-50 PIN 1 1 7
H-32-0512-50 PIN 1 1 8
H-32-0512-50 PIN 1 1 9
H-37-4122-01 INDUCTOR ASSEMBLY 1 2 6
H-39-0001-06 RECEIVER/EXCITER GREEN 1 2 1
H-39-0001-12 RECEIVER/EXCITER(GREEN) 1 1 1
my cl query is below:
PARAMETERS [CocNo] Text ( 255 );
SELECT DISTINCTROW Liste.PartNumber, Liste.Description, Liste.Qty,
Liste.CocNo, Liste.SerialNumber
FROM Liste
GROUP BY Liste.PartNumber, Liste.Description, Liste.Qty, Liste.CocNo,
Liste.SerialNumber
HAVING (((Liste.CocNo)=[CocNo]));
I tried to figure out below sql.
SELECT cl.PartNumber, Concatenate("Select SerialNumber FROM cl WHERE
PartNumber =""" & [PartNumber] & """") AS SerNo, cl.CocNo
FROM cl
GROUP BY cl.PartNumber, cl.CocNo;
But it is not working shows run time error.I need to use parameter of
CocNo:1 and 2.
If I coud not use parameter ,I figured out hookom concatenate
for coc1:
H-32-0512-50 ser no:1,2,3,7,8,9
H-39-0001-12 ser no:1
for coc2:
H-32-0512-50 ser no:5
H-37-4122-01 ser no:6
H-39-0001-06 ser no:1
I would appreciate if I could get a quick response
ibo
I have to concatenate serial number according to part number and Coc No
Part Number Description Qty CoC No Serial Number
H-32-0512-50 PIN 1 1 1
H-32-0512-50 PIN 1 1 2
H-32-0512-50 PIN 1 1 3
H-32-0512-50 PIN 1 2 5
H-32-0512-50 PIN 1 1 7
H-32-0512-50 PIN 1 1 8
H-32-0512-50 PIN 1 1 9
H-37-4122-01 INDUCTOR ASSEMBLY 1 2 6
H-39-0001-06 RECEIVER/EXCITER GREEN 1 2 1
H-39-0001-12 RECEIVER/EXCITER(GREEN) 1 1 1
my cl query is below:
PARAMETERS [CocNo] Text ( 255 );
SELECT DISTINCTROW Liste.PartNumber, Liste.Description, Liste.Qty,
Liste.CocNo, Liste.SerialNumber
FROM Liste
GROUP BY Liste.PartNumber, Liste.Description, Liste.Qty, Liste.CocNo,
Liste.SerialNumber
HAVING (((Liste.CocNo)=[CocNo]));
I tried to figure out below sql.
SELECT cl.PartNumber, Concatenate("Select SerialNumber FROM cl WHERE
PartNumber =""" & [PartNumber] & """") AS SerNo, cl.CocNo
FROM cl
GROUP BY cl.PartNumber, cl.CocNo;
But it is not working shows run time error.I need to use parameter of
CocNo:1 and 2.
If I coud not use parameter ,I figured out hookom concatenate
for coc1:
H-32-0512-50 ser no:1,2,3,7,8,9
H-39-0001-12 ser no:1
for coc2:
H-32-0512-50 ser no:5
H-37-4122-01 ser no:6
H-39-0001-06 ser no:1
I would appreciate if I could get a quick response
ibo