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
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!