Hi: I am relatively new to access and need to design a form. Have layout complete but now need to bring in a formula currently used in excel. Basically the formula will return a value under certain given criteria. Formula states:
=IF(B4<8,5,IF(B4<50,8,IF(B4<90,13,IF(B4<150,20,32))))
Used for determing sample sizes based on batch size. We designing a datavbse that will be as user frindly as possible and automatically retuirn info to the person using.
Can someone out there advise how to bring this formula into the access form?
Thanks a million.
=IF(B4<8,5,IF(B4<50,8,IF(B4<90,13,IF(B4<150,20,32))))
Used for determing sample sizes based on batch size. We designing a datavbse that will be as user frindly as possible and automatically retuirn info to the person using.
Can someone out there advise how to bring this formula into the access form?
Thanks a million.