June 23, 200322 yr I was after, if possible, a script or some way to have TEXT not printed if a field calculation was not used. If that particular calc. is used then the TEXT will show/print. EG. PRINT VIEW 2hrs X $50.00p/hr= $100.00 CALC USED CALC NOT USED If there is NO input for the Calc to be used (not needed), then the X & the = will not be printed. The reason i want to do this is for a QUOTE FORM. When certain aspects (fields) are not used then i dont want to see the multiplication and equalls signs on the layout when it is not required for that particular QUOTE. Any help would be appreciated.
June 23, 200322 yr Use the IsEmpty with your calculation. In other words: Case(IsEmpty(FIELDWITHCALC), "", "2hrsX $50.00p/hr=$100.00") Sub your own field for FIELDWITHCALC and adjust the 2hrsX $50.00p/hr=$100.00 part so that it matches fields or quotes, etc. HTH Lee
Create an account or sign in to comment