Hi all,

I have been given the task of cleaning up an old db. One thing I'd like to do is combine 3 text fields into 1 new field.
In the old db there was a form that included 3 memo text boxes, when the first one was full the user then started using the second and then the third. The relating Table fields are message, overflow message & overflow message extended.

I'd like to combine the fields into 1 and then design a new form to suit so that the memo text in the new db goes into 1 field only.

Hello:

You need to concatenate the fields in query. Please see my enclosed example: Open the query qryFields
Regards
Mark

Thanks Mark, That worked a treat