concatenate

[IMOS]

Hi!
I am new in the forum and also in access...
Sorry if my question is really basic.
Is it posible to create a new variable in a table with the sum of other two string variables in the same table?
Thank you in advance.
I am a physician working in Guinea-Bissau and we are trying to develop a database for our HIV clinic. We dont have much experience, but we need to learn more.

Thank you indeed

 

[pbaldy]

Typically you would do this in a query, since it doesn't really have to be saved. In design view:

NewField: Field1 & Field2

 

[IMOS]

Concatenate

Typically you would do this in a query, since it doesn't really have to be saved. In design view:

NewField: Field1 & Field2

Thank you Pbaldy!!
But if i would like to save it, it would be posible to make it in a table?
This is because the number of our patients is a eleven figure number, and the first 6 figure numbers is the code of the clinic. For making easy the entry of the data, we split the number of the patient in two (the first part that is constant and the second part). Now we would like to put both together for using this new variable as key variable for makeing the relationships with the laboratory table.
I am sorry if I dont explain myself very well. Hope you can understand what I mean.
Thank you very much!

 

[pbaldy]

I would use code rather than a macro, but here's one way:

http://support.microsoft.com/kb/209172/en-us