Can I add data from 3 fields together to form a new field

Can I add data from 3 fields together to form a new field

You can concatenate the values for display purposes. For instance:

[City] & ", " & [State] & " " & [PostalCode]

If you mean something else, please provide details.

"Jack Grossman" Jack wrote in message
...
Can I add data from 3 fields together to form a new field

The answer is "yes". You would only want to do this in a query you would not
want to do this
in a table as that is redundent and will quickly introduce data errors.

So you have text fields of FirstName, MiddleName and LastName. To add them
together ( really
concatenate them) as follows: txtFullName = FirstName & " " & MiddleName
& " " & LastName.

Or if you have numeric fields of BasePrice, DiscountRate, Sales Tax. To
add them together
try txtCost = BasePrice - (DiscountRate * BasePrice) + Sales Tax

Regards

Kevin


"Jack Grossman" Jack wrote in message
...
Can I add data from 3 fields together to form a new field

To clarify a little, in an unbound text box you could have as the Control
Source:
= FirstName & " " & MiddleName & " " & LastName

In a query:
txtFullName: FirstName & " " & MiddleName & " " & LastName

That is, no = sign in the query.

"kc-mass" connearney_AT_comcast_DOT_net wrote in message
...
The answer is "yes". You would only want to do this in a query you would
not want to do this
in a table as that is redundent and will quickly introduce data errors.

So you have text fields of FirstName, MiddleName and LastName. To add
them together ( really
concatenate them) as follows: txtFullName = FirstName & " " & MiddleName
& " " & LastName.

Or if you have numeric fields of BasePrice, DiscountRate, Sales Tax. To
add them together
try txtCost = BasePrice - (DiscountRate * BasePrice) + Sales Tax

Regards

Kevin


"Jack Grossman" Jack wrote in message
...
Can I add data from 3 fields together to form a new field