dbTalk Databases Forums  

Ways to calculate Pass/Fail result based on range of numbers

comp.database.ms-access comp.database.ms-access


Discuss Ways to calculate Pass/Fail result based on range of numbers in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
MTHarris
 
Posts: n/a

Default Ways to calculate Pass/Fail result based on range of numbers - 11-27-2003 , 08:50 PM






I have a form I am working on. On that form I have fields which perform
calculations. What is the easiest way to define a pass or fail result based
on those numbers from the calculations being compared to a range of numbers.
For example the number 45 being compared to a range of 25-60 and since it
falls within concludes with a Pass result. The thing is there will be 20 or
so conclusions each one has its own range for comparison and a pass result
is contingent to all falling within there assigned ranges. So any
individual result/calculation out of range would come up Fail. ? I know
it is probably elementary... lol but me still Noob.. but trying

Any help appreciated

MTHarris



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.