Karen has attended:
Access Intermediate course
Combining Fields into one row
I have created a query with 3 "or" criteria in separate column fields. This has created 3 rows for each item. How can I create a query or report that combines the 3 rows into one row so that the column fields are side by side?
Ie, Convert from:
Column1 Column2 Column3
Row 1a abc
Row 1b def
Row 1c ghi
to
Row 1 abc def ghi
Thanks
Karen
RE: Combining Fields into one row
Hi Karen
Try and use the following function to join the fields together
1. Go to a new field in your query.
2. Type a name for your field in the first row
ie. MyfieldName:
3. Then ADD the fields together as follows
Field1 +" "+Field2+" "+Field3
4. The complete formula looks like this:
MyfieldName:Field1 +" "+Field2+" "+Field3
5. The " " are to insert blank spaces in between the fields. If you want it all joined to gether, justs remove the " ".
This method is similar to the CONTATENATE function in Excel.
Let me know if it works
Regards
Richard
