Hello,

I have a formula in excel that I am using to come up with the check digit in excel like this:

=MOD(10 - MOD( SUMPRODUCT(MID(A2, {1,2,3,4,5,6,7,8,9,10,11,12,13}, 1) * {3,1,3,1,3,1,3,1,3,1,3,1,3}), 10), 10)

where A2 is equal to 2001234567890

after the calculation i come up with =9

I want to do this calculation into a query, since in access is where i generate my Gtin numbers. (A2)


how can i put that formula in Microsoft access?