Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Location
    Arkansas
    Posts
    2

    Talking Unanswered: UPC Check digit calculator

    Good day all.
    I am in need of some help. I currently have a database for inventory, and I need to create a Check Digit calculator in Access. I have it in Excel, where it goes like this...

    =MOD(10-(MOD(((DIGIT1+DIGIT3+DIGIT5+DIGIT7+DIGIT9+DIGIT11) *3)+(DIGIT2+DIGIT4+DIGIT6+DIGIT8+DIGIT10),10)),10)

    If I name the fields the same, what should my expression look like?

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    In Access Mod is an operator and not a function. You would use it just like multiplication *.

    123 Mod 2 would equal 1

  3. #3
    Join Date
    Sep 2006
    Location
    Arkansas
    Posts
    2

    Talking

    Got it, actually found that yesterday before I read your posting. Thanks! now I have to fix my results, because when I used Mid... and then used the addition, something funky happend. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •