Forum home » Delegate support and help forum » Microsoft Access Training and help » database+courses+london - Combining Fields into one row
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
database+courses+london - Combining Fields into one row
Resolved · Low Priority · Version Standard
Reply Fri 9 Nov 2007, 17:04Delegate Karen said...
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
For upcoming training course dates see: Pricing & availability
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
|