pxj05
asked on
Concatenate records with same data across two fields
Hi
I am using MS ACCESS 2003 on XP Pro and was hoping you could help me.
I have a query that displays duplicate records based on two fields. I would like concatenate all dupicate data into one record. For example (field names first row):
F1, F2, F3
A, 2, Church
A, 2, Library
B, 1, Station
B, 1, <Null>
B, 1, Post Office
C, 5, Hall
I would like to concatenate as follows:
F1, F2, F3
A, 2, Church Library
B, 1, Station <Null> Post Office
C, 5, Hall
Ideally I would like the solution in SQL but if its best to use vba please supply basis if you can.
Thanks
I am using MS ACCESS 2003 on XP Pro and was hoping you could help me.
I have a query that displays duplicate records based on two fields. I would like concatenate all dupicate data into one record. For example (field names first row):
F1, F2, F3
A, 2, Church
A, 2, Library
B, 1, Station
B, 1, <Null>
B, 1, Post Office
C, 5, Hall
I would like to concatenate as follows:
F1, F2, F3
A, 2, Church Library
B, 1, Station <Null> Post Office
C, 5, Hall
Ideally I would like the solution in SQL but if its best to use vba please supply basis if you can.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER