Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    17

    Unanswered: Greatest common divisor

    How to find Greatest common divisor in MS Access?
    Have a 2 columns in my form: 1) amount; 2) GCD

    E.G

    amount | GCD
    1200
    500
    400
    100

    Should be after runing code

    amount | GCD
    1200 | 12
    500 | 5
    400 | 4
    100 | 1

    I was looking form some function but I found only for Ms Excel :/

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so write a function that does this
    ... as effectively has been suggested here:-
    Greatest common divisor - Access World Forums

    this gives you a possible strategy
    MS SQL Script for Greatest Common Divisor (GCD)

    you could implement it either as a VBA function or a stored procedure
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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