G
Guest
I am trying to create a listbox that uses values from
three fields and another listbox to solve and display a
value. I have tried to use, with modifications for the
format, a formula from excel. When I finished, the box
displayed "#Name?". Is "If" an illegal perameter, or is
there some other problem in the form?
I need to set up a listbox that divides the value of
another listbox according to the values of three fields in
the form. Two fields are simple values that can be
plugged into the expression, but the other is a text field
that has a corresponding numerical value that must be
used. The expression I was trying to use looks like...
If([Size]="2X4",([Load]/([Depth]*4.25)),If ... Does
anyone have an idea for me?
three fields and another listbox to solve and display a
value. I have tried to use, with modifications for the
format, a formula from excel. When I finished, the box
displayed "#Name?". Is "If" an illegal perameter, or is
there some other problem in the form?
I need to set up a listbox that divides the value of
another listbox according to the values of three fields in
the form. Two fields are simple values that can be
plugged into the expression, but the other is a text field
that has a corresponding numerical value that must be
used. The expression I was trying to use looks like...
If([Size]="2X4",([Load]/([Depth]*4.25)),If ... Does
anyone have an idea for me?