Barheard, I have a field of 12 Numbers, I want to generate bar code 13, through the following the IIF I got a barcode mantissa,
IIf(10-(((Mid([barheard],2,1)+Mid([barheard],4,1)+Mid([barheard],6,1)+Mid([barheard],8,1)+Mid([barheard],10,1)+Mid([barheard],12,1))*3+Mid([barheard],1,1)+Mid([barheard],3,1)+Mid([barheard],5,1)+Mid([barheard],7,1)+Mid([barheard],9,1)+Mid([barheard],11,1)) Mod 10)=10,0,10-(((Mid([barheard],2,1)+Mid([barheard],4,1)+Mid([barheard],6,1)+Mid([barheard],8,1)+Mid([barheard],10,1)+Mid([barheard],12,1))*3+Mid([barheard],1,1)+Mid([barheard],3,1)+Mid([barheard],5,1)+Mid([barheard],7,1)+Mid([barheard],9,1)+Mid([barheard],11,1)) Mod 10))
But with the 12 digit number in different EXCEL by using the following formula number??? I don't know why?
=IF (10 - MOD (((((MID (I2573, 2, 1) + MID (I2573, 4, 1) + MID (I2573, 6, 1) + MID (I2573, 8, 1) + MID (I2573, 10, 1) + MID (I2573, 12, 1)) * 3) + MID (I2573, 1, 1) + MID (I2573, 3, 1) + MID (I2573, 5, 1) + MID (I2573, 7, 1) + MID (I2573, 9, 1) + MID (I2573, 11, 1))), 10)=10,0,10 - MOD (((((MID (I2573, 2, 1) + MID (I2573, 4, 1) + MID (I2573, 6, 1) + MID (I2573, 8, 1) + MID (I2573, 10, 1) + MID (I2573, 12, 1)) * 3) + MID (I2573, 1, 1) + MID (I2573, 3, 1) + MID (I2573, 5, 1) + MID (I2573, 7, 1) + MID (I2573, 9, 1) + MID (I2573, 11, 1))), 10))
Such as the number with ACCESS to draw is 8, 303021011001 in EXCEL is 2
This is where there is a problem, how can draw like EXCEL in ACCESS number, help masters,