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

  • Thread starter Thread starter Jack Grossman
  • Start date Start date
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
 
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.
 
Back
Top