Case Functions

[jdhunter]

I'm using Cases functions to do a few caculations for me and for the most part they work quite well. What happens sometimes is that they decide to not work sometimes. What i'm doing is using them to pull information from another table/field if a field is defined in a certain way any reason that these would not work. Anyhelp here would be great.

Thanks,

Jonny

[LaRetta]

You need to provide more information. Provide the Case() statements. Provide your structure. :wink2:

[comment]

they decide to not work sometimes

Maybe you're not paying them enough.

[LaRetta]

I suspect that your Case() calculations are only evaluating the FIRST related record. Is this a one-to-many situation? But then again ... maybe Michael is correct. When's the last time those calcs got a raise? :wink2: