merging many side of query into one large record

Help.Chris

Registered User.
Local time
Today, 09:25
Joined
Oct 11, 2000
Messages
43
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.
 

Users who are viewing this thread

Back
Top Bottom