• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

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.
0
nravida
Asked:
nravida
  • 4
  • 3
1 Solution
 
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?
0
 
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.
0
 
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...
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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. :)
0
 
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.
0
 
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.
0
 
lesouefCommented:
lab tech thrown the job
---------
we're many who started this way!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now