database+courses+london - 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