G
Guest
I need to do a calculation on a report but the calculation only needs to be
done if one of the fields reads Fanfold. I have tried to come up with a
formula for this but access keeps asking me for a number for Fanfold.
What I need is something to this effect.
If the Box Type field is Fanfold then ProductLength*Boxes Needed then add 4
then divide by 12 if it's not fanfold I just want a blank field.
As always any help would be appreciated.
done if one of the fields reads Fanfold. I have tried to come up with a
formula for this but access keeps asking me for a number for Fanfold.
What I need is something to this effect.
If the Box Type field is Fanfold then ProductLength*Boxes Needed then add 4
then divide by 12 if it's not fanfold I just want a blank field.
As always any help would be appreciated.