G
Guest
I hope someone can tell me how to “convert†field value to field name
I have a table with test results for a lot of samples
I have different field name which is named equivalent to the type of the
microbe 16, 33, 41, 67 etc.
Each record consist of a sample with 0 to 4 test results stored as Res1,
Res2, Res3, Res4
(i.e. Res1 = 16, Res2 = 33), data type = text
Interesting field names for this record are: SampleID, 16, 33, Res1, res2
Values are imported from another system and the record will be as such (i.e.):
8765,,,16,33
I want to make a procedure which store the Res1-value (16) into the field
name field name with same value (16) (and the Res2-value (33) into the field
name with same value (33)
After the procedure the values in the same record should be: 8765,16,33,,,
If having a field name with only numbers creates problem, the field names
could be initiated with MIC (i.e. MIC16, MIC33, MIC41, MIC67)
*gublues
I have a table with test results for a lot of samples
I have different field name which is named equivalent to the type of the
microbe 16, 33, 41, 67 etc.
Each record consist of a sample with 0 to 4 test results stored as Res1,
Res2, Res3, Res4
(i.e. Res1 = 16, Res2 = 33), data type = text
Interesting field names for this record are: SampleID, 16, 33, Res1, res2
Values are imported from another system and the record will be as such (i.e.):
8765,,,16,33
I want to make a procedure which store the Res1-value (16) into the field
name field name with same value (16) (and the Res2-value (33) into the field
name with same value (33)
After the procedure the values in the same record should be: 8765,16,33,,,
If having a field name with only numbers creates problem, the field names
could be initiated with MIC (i.e. MIC16, MIC33, MIC41, MIC67)
*gublues