I can't seem to make my formula work

  • Thread starter Thread starter Dani.
  • Start date Start date
D

Dani.

Hi, I posted this, but it was my first time and now I can't find it. Sorry if
anyone answered. So, I would like field to work out a formula that goes
something like field x=field y when field a < field b. Please help......
 
Thank-you. I didn't have the commas in. However, I'm still doing something
wrong. I'm in the 'supporting objects' section. Is this right, or should I be
looking at the 'inventory' section? It won't work it out in the supporting
objects and when I click on the inventory list it comes up with "enter
parameter value" and inventory.discontinued. Do I have to bind the fields
that I want to use, if so, how do I do this? P.S To answer your question,
YES, I am useless.....

KARL DEWEY said:
Try this --
IIF([field a] < [field b], [field y], [field x])

--
Build a little, test a little.


Dani. said:
Hi, I posted this, but it was my first time and now I can't find it. Sorry if
anyone answered. So, I would like field to work out a formula that goes
something like field x=field y when field a < field b. Please help......
Click to expand...
Click to expand...
 
Back
Top