Simplest concatenation

I have been given the task of developing a database for our lab and so I am very much a beginner. Excuse the
simple question.

How do I write the calculation for concatenating 5 fields?
RP #
Tank
Rack
Level
Position
I tried RP# & Tank & Rack & Level & Position  and it only shows the RP #
I have tried other variations with the " " and "_" and I can't figure out this simple task.
nravidaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lesouefCommented:
& is the correct concatenation sign, if it does not work, the pb is somewhere else: is the calculated field the correct type (text?)
by calculation, do you mean to define a calculated field or just to chain these fields to show them in a layout?
nravidaAuthor Commented:
It is in text mode
I was attempting to make a unique field by combining these five fields.
I was under the impression all I had to do was give it a calculated value as
RP # & Tank & Rack & Level & Position

I basically need a way for the inventory sheet to recognize this field versus all the other vials that may be frozen with the same RP# in the same tank, rack, level but a different position.
lesouefCommented:
I was under the impression all I had to do was give it a calculated value as
RP # & Tank & Rack & Level & Position
----------
it is correct...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

nravidaAuthor Commented:
I figured out what I had done wrong. I had checked the box labeled "Do not replace existing value of field" and therefore it would only paste the first field I filled in. I appreciate your help without it I wouldn't have known it wasn't the actual concateenation that was wrong but that small piece. :)
lesouefCommented:
ha! so that was not a calculated field, but an auto-entered field from calculation, and it does have that feature.
major differences between calculations and auto-entered fields:
calculation fields do not store values, they are calculated upon display or print; they are dynamic and cannot be changed by any user.
auto-entered field (if do not replace... is off) are also dynamic upon other field change, store the result in the database, and can be altered by a user. But on any change of any of the fields which are making it, thay will be recalculated again. searching in this type of field is quicker.
nravidaAuthor Commented:
Like I said, I am a serious beginner and therefore know none of the vocabulary. Just a simple lab tech thrown the job of making our database gel.  Sorry about the confusion but thanks again. I am sure there will be many future questions.
lesouefCommented:
lab tech thrown the job
---------
we're many who started this way!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.