By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,968 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,968 IT Pros & Developers. It's quick & easy.

How to combined two fields in MS-Access2007?

100+
P: 180
How to combined two fields in MS-Access2007?
Aug 3 '10 #1

✓ answered by Jerry Maiapu

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);

Expand|Select|Wrap|Line Numbers
  1. me.fld3=me.fld1 & " "& me.fld2 'seperated by a space
To display the combined result in a message box;
Expand|Select|Wrap|Line Numbers
  1. Msgbox fld1 & " " & me.fld2 'seperated by a space
if in a query:
................
Field 1 =fld1
Field 2 =fld2
................
then,

Expand|Select|Wrap|Line Numbers
  1. Field 3: [fld1]+[fld2]
It's pretty difficult to predict what you are trying to get across...but that is the idea..

JM

Share this Question
Share on Google+
2 Replies


Jerry Maiapu
100+
P: 259
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);

Expand|Select|Wrap|Line Numbers
  1. me.fld3=me.fld1 & " "& me.fld2 'seperated by a space
To display the combined result in a message box;
Expand|Select|Wrap|Line Numbers
  1. Msgbox fld1 & " " & me.fld2 'seperated by a space
if in a query:
................
Field 1 =fld1
Field 2 =fld2
................
then,

Expand|Select|Wrap|Line Numbers
  1. Field 3: [fld1]+[fld2]
It's pretty difficult to predict what you are trying to get across...but that is the idea..

JM
Aug 3 '10 #2

100+
P: 180
thnx alot..
Aug 5 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.