Several Rows into a single Row

[carfj1]

I have a list of OrderIDs which need to be Printed on a Report in a single Row.

I have:
OrderID
001
002
004
008

How can I make:
001, 002, 004, 005

The report has a query with all the OrderIDs that are required. But I think this has to be done with a Function or something...


Thanks for your time,
Carlos

 

[Lightning]

Possibly a Crosstab query could achieve what you are after.

HTH
Lightning

 

[carfj1]

Lightning,

I tried it with a 3 columns on a Query, as base query

OrderID txtID OrderID
001 1 001
002 1 002
005 1 002

With a [Formularios]![Facturas]![txtID]as criteria for the base query of the Cross tab. It didn't work because the cross tab can't use this kind of criteria. "At least to what I now"

Thanks,
Carlos