Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    15

    Unanswered: Calculation query

    In my database i have a query with the field as BMI: [Weight kg]/([Height m]*[Height m])

    this give the correct value if all i want is to have a list of all value, however i want to know the number of records with the value between 15 and 25 and when i put this in the criteria and go to view the results a msg appears saying overflow and no data appears. Can somebody help me with this

    Cheers

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    Probably one of your records has a height of 0, when you do a divide by zero you get the overflow message.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

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