View Single Post
  #2  
Old April 1st, 2010, 11:56 PM posted to microsoft.public.access.gettingstarted
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Combining Two Fields in One Calculated Field

It's rarely necessary or a good idea to store a calculated value like this.
Instead, use a query.

You could:

* create a new query in design view
* add the table(s) that has these fields
* create a new output field, perhaps like: NewField: [FName] & " " &
[LName]

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"PlarfySoober" wrote in message
...
Somebody wrote on this forum recently how to do this. In a table or a
query,
maybe both, and it was really simple and clever but I failed to print it
for
my notes.

Take FName+" "+ LName, call them by another name (field name?) so that
when I create a report, I don't have to worry about where to place the
elements of a name so they look smooth and all melody and fine.

Is this possible in a mere table? If not, please how do you do it in a
query, and I promise to print it.

TYIA.

Don.