How can I do this??

[Marco]

hello. How can I transform this:

ID_Cabec ID_Lote Lote QTPalete QTExpedida Palete Cestos Cap
56 1486 A023 0,4 0,4 14171 999 15
56 1486 A023 154,733 154,733 14171 67-73 15

into this, one line only:
ID_Cabec ID_Lote Lote QTPalete QTPalete Palete Cestos
Cap
56 1486 A023 155,133 155,133 14171 999 67-73 15


Sorry for the formatting, I try to put it in the best view.

Any ideas? is it possible?

Regards,
Marco

 

[John W. Vinson/MVP]

hello. How can I transform this:

ID_Cabec ID_Lote Lote QTPalete QTExpedida Palete Cestos Cap
56 1486 A023 0,4 0,4 14171 999 15
56 1486 A023 154,733 154,733 14171 67-73 15

into this, one line only:
ID_Cabec ID_Lote Lote QTPalete QTPalete Palete Cestos
Cap
56 1486 A023 155,133 155,133 14171 999 67-73 15


Sorry for the formatting, I try to put it in the best view.

Any ideas? is it possible?

Regards,
Marco

I don't understand the logic, Marco. How does 0,4 and 154,733 map into
155,133? What happened to the 14171 value in Palete? Are these all
Text fields; and are the commas decimal delmiters, or are you <uck>
storing multiple text strings in one field? In your desired result you
have two fields named QTPalete - is that a typo, or intentional (you
cannot have two fields with the same name?)

 

[Marco Silva]

Hi. Thanks. Sorry that I'm only came to you now.

I hope you'll understand my answers:

1 - How does 0,4 and 154,733 map into 155,133? »» this is by summing.

2 - What happened to the 14171 value in Palete? »» The pallete number is
the same, so it should keep it, but in only one row.

3 - Are these all Text fields »» only the fields Cestos and Lote are stored
as text.

4 - And are the commas decimal delmiters? »» in portugal commas are decimal
separator simbol.

5 - Storing multiple text strings in one field? »» Yes, I need that
merger/concatenate all fields content in only one.

I know that this is hard.

I'll try to modify my program. I'll try to make a cross-table query.


Thanks,
Marco