How to combined two fields in MS-Access2007?

**Jerry Maiapu** · Aug 3 '10, 03:23 AM

This is fairly simple. I recommed you to read more MS Access Databse design Basics and abit of VB programming concept.

Your question is not explicit in nature.

To join 2 fields (fld1, fld2) in a form and display in a third text box (fld3);

Code:

me.fld3=me.fld1 & " "& me.fld2 'seperated by a space

To display the combined result in a message box;

Code:

Msgbox fld1 & " " & me.fld2 'seperated by a space

if in a query:
............... .
Field 1 =fld1
Field 2 =fld2
............... .
then,

Code:

Field 3: [fld1]+[fld2]

It's pretty difficult to predict what you are trying to get across...but that is the idea..

JM

**eneyardi** · Aug 5 '10, 09:47 AM

thnx alot..

How to combined two fields in MS-Access2007?

How to combined two fields in MS-Access2007?

Comment

Comment