Combine 3 text fields into 1 (1 Viewer)

[Knivag]

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.

 

[mhartman]

Hello:

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

 

[Knivag]

Thanks Mark, That worked a treat