database+courses+london - Combining Fields into one row

Resolved · Low Priority · Version Standard

Fri 9 Nov 2007, 17:04 Delegate 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

Mon 12 Nov 2007, 17:13 Trainer Richard said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips