473,471 Members | 2,138 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How to combined two fields in MS-Access2007?

180 New Member
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

2 1606
Jerry Maiapu
259 Contributor
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
eneyardi
180 New Member
thnx alot..
Aug 5 '10 #3

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

Similar topics

5
by: ND | last post by:
I need to create a separate field from 4 fields, "street address", "city", "State" and "zip code". For example, Street address - 100 Forest Street City - Seattle State - WA Zip - 05555 ...
1
by: moischmoe | last post by:
I am using MS Access 2000. I have a database that I use to keep weekly attendance records. In my table, each record consists of the fields: name, week 1, week 2, week 3, ect...(each week I add a...
1
by: Riley DeWiley | last post by:
I have an application with two tables, A and B. Each has an autonumber unique ID field, plus other data. I have a junction table, AB, containing fields AID, BID, and Count (a number). AB has...
0
by: pnp | last post by:
Hi all, I would like to create a component that simulates the functionality of an MS Access table, through a Datagrid combined with comboboxes, datetime selectors and checkboxes. So when a table...
2
by: marco | last post by:
Dear List, as it seems, MS SQL as used in Access does not allow a select INTO within a UNION query. Also, it seems that a UNION query can not be used as a subquery. Maybe my (simplified)...
9
by: Fish Womper | last post by:
I am at best a part time developer of Access databases. I use Access 2.0, as this is all my employer has on its computers. Even so, to use this ancient version requires a fairly convoluted...
2
by: Jimmy | last post by:
Here's my issue. I'm using a calculated control to combine two fields on a form & report. The two fields are RecordID (the autonumber primary key) and a field named ProductCost. The idea is to...
3
by: bimgot | last post by:
hi i am using ms access to print some address labels using a thermal label printer. to do this i've combined and trimmed the name and address fields into one new field called "label" in order to...
2
by: TroutmansRegistrar | last post by:
I have a web programming task that has me stumped. I hope that one of you could give me some insight or might know someone who could guide me in the right direction. This is the final piece of the...
10
Dököll
by: Dököll | last post by:
Hey Guys! I ran into a puzzle; below query gets me what I need (Difference from two time fields) in Ms Access 2000 but not in MS Access 2003, any idea why: SELECT Data.ID,...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.