How can I make this in a query

  • Thread starter Thread starter Marco
  • Start date Start date
M

Marco

Hi,

I would like to do something dificult here in a query.

I have a query showing this:

Produtos Fabrico/Lotes NumCesto Quantidade
SFG.4USJH A013 9 2310
SFG.4USJH A013 10 1794
SFG.4USJH A013 11 2310

I would like to pass to this: (only in the query)

Produtos Fabrico/Lotes NumCesto Quantidade
SFG.4USJH A013 9-10-11 6414


Thanks,
Marco
 
Hi,

I would like to do something dificult here in a query.

I have a query showing this:

Produtos Fabrico/Lotes NumCesto Quantidade
SFG.4USJH A013 9 2310
SFG.4USJH A013 10 1794
SFG.4USJH A013 11 2310

I would like to pass to this: (only in the query)

Produtos Fabrico/Lotes NumCesto Quantidade
SFG.4USJH A013 9-10-11 6414
Click to expand...

You'll need a bit of VBA code to concatenate the individual record values in
NumCesto. See http://www.mvps.org/access/modules/mdl0004.htm for sample code.
 
Back
Top