Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ratio calculation (Access2000-03)

    Hi!
    How do I calculate ratio A to B of the values in colomns A and B?

    Thanks

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Ratio calculation (Access2000-03)

    To calculate a ratio of one number to another , you just divide one number by the other.

    So the ratio of of 5 to 8 is 5:8 or 5/8.

    To do this in a query you would need to add a calculated field to the query:
    Ratio: [a]/<!t>[b]
    Regards
    John



Posting Permissions

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