Search results

Thank you so very much!!!!!!!!!!!!!!!!!! Both formulas work well!!!

Thank you very much for the quick reply, but I am still not getting the result of when the qty is greater than 1000 to return "200 PER".

:o Please help... I am trying to get the following results. If the Qty is less than 99 bag 10 per, if the qty is between 100 and 999 bag 100 per and if the qty is greater than 999 bag 200 per. Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]>99,"100 PER",IIf([QTY]>999,"200 PER")))) I am only getting...

Thanks MStef But can you help me understand what exactly to do with this. However I am still confused... When I go to the On Click in the properties on my first button on the switchboard. OnClick=HandleButtonClick(1). If I Click on this one it takes me to our contracts. How do I get further to...

Thank you for the information... I appreciate it... However I am still confused... When I go to the On Click in the properties on my first button on the switchboard. OnClick=HandleButtonClick(1). If I Click on this one it takes me to our contracts. How do I get further to make sure that the...

Thanks for the information.... but what do you mean "Look at a field WPass, Default value properties. Look at VBA." I am lost

:confused: I need some help... I have created a wonderful switchboard but need to add some security to it. There is about 50 users in this DB and I tried to use the Security wizard to set everybody up...It created a huge problem! It did not just secure this database but it secured every database...