Hi everyone,

I have a database, with a one to many join, the one side is correct, but the many side i could do with merging into one record in a query.

ie.

1 side: campaign, code, id

many side: destination code

currently the many side contains data in the format MAN
LPL
GTW
I could do the the query outputting MAN, LPL, GTW as one record.

This would result in me getting one record for each item in the database, rather than several due to the many join.

Does anyone know if this is possible, i would be a great help if it is.

Chris

If you are attempting to do this for a form or report, it is not necessary. Use a main form/report for the one-side data and a subform/subreport for the many-side.