Combining Data.

[Antonio]

I have a table containing 3 data fields. Combined the
datafields represent one unique number, but for sorting
purposes I broke the 6 digit number down into 3, 2 digit,
fields. I want to combine the numbers into their original
6 digit form. Is there a way to do this in access?

Example:
Medical Record Number = 564327
Current Database = MR1=56, MR2=43, MR3=27.
New Database = MR# = 564327
Is there a way to take all of the previous data in MR1, 2,
and 3, and combine them to form the original, complete MR
numbers in one new datafield for each mr#?

I tried an append query, but that just added the values
for MR2 after all the values of MR1...so in the end I
ended up one column of data with triple the amount of the
original records.
tia
antonio

 

[Frits van Soldt]

Something like this:
update [tablename] set MR# = MR1 & Mr2 & Mr3

 

[Jeff C.]

1. Create a new field called "Combined" (or whatever).
2. Create an update query which in SQL view looks like
this...
UPDATE xxx SET xxx.Combined = [MR1] & [MR2] & [MR3]

replace xxx with your actual table name.