C
Clyde Thorne
I am using MS Access 2003. I make several small queries to extract all of
the
information I need from existing tables that have been imported in. I do
this because I need to concatenate some of the cells before I moved them
over to the larger query. One of the cells of the smaller query have this
information in it,
"SLAB;TWO(D8R2SLAB;ONE(S10~E9~E9~N10~L18)R18R2RPO;ONE(R15U1U5L15D6)U6R15U10L17UBM;ONE(U12L12D12R12)L12L8D8)
SLAB;ONE(L10U2UBM;ONE(L18U34R18OH(U2R37D2UBM;TWO(R14WOD(U8R25D23GAT(D28L29U5U10U13R4R25)L25U15)D15L4D13
L17U12L12D12L8U4L10U10R8U14R29)L29L8)R8D14L8D10D10)U10R10D4D8)RPO;RPO(D8L10U8R10)FBM(1800)
". When I make my larger query, and transfer all of the information from
the smaller queries into the larger query, I lose about 1/3 of the
information in that one cell. Any idea why I would lose this information.
clyde
the
information I need from existing tables that have been imported in. I do
this because I need to concatenate some of the cells before I moved them
over to the larger query. One of the cells of the smaller query have this
information in it,
"SLAB;TWO(D8R2SLAB;ONE(S10~E9~E9~N10~L18)R18R2RPO;ONE(R15U1U5L15D6)U6R15U10L17UBM;ONE(U12L12D12R12)L12L8D8)
SLAB;ONE(L10U2UBM;ONE(L18U34R18OH(U2R37D2UBM;TWO(R14WOD(U8R25D23GAT(D28L29U5U10U13R4R25)L25U15)D15L4D13
L17U12L12D12L8U4L10U10R8U14R29)L29L8)R8D14L8D10D10)U10R10D4D8)RPO;RPO(D8L10U8R10)FBM(1800)
". When I make my larger query, and transfer all of the information from
the smaller queries into the larger query, I lose about 1/3 of the
information in that one cell. Any idea why I would lose this information.
clyde