我有一個欄位barheard,12位的數字，我想生成13位的條形碼，通過以下這個IIF我得到一個條形碼的尾數，
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))
但是與這個12位數字在EXCEL運用以下公式得出的數字不同？不知為什么？
=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))
如303021011001這個數字用ACCESS得出的是8，在EXCEL中得出的是2
這個是那里有問題，如何能在ACCESS中得出與EXCEL一樣的數字。求助大師們指點，
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/275215.html
標籤：Access