Newbies monfa9 Posted December 9, 2000 Newbies Share Posted December 9, 2000 I'm still learning the rules of calculations. Can someone please give me an example of how exactly the formula should look. The field name being tested is CLIENT and the first test would be HOUSE with the result being OSO1 and the second test would be HOUSE 2 with the result being OSO9. Thanks a lot!! Case ( test1 , result1 Link to comment Share on other sites More sharing options...
LiveOak Posted December 9, 2000 Share Posted December 9, 2000 Case( CLIENT = "HOUSE", "OSO1", CLIENT = "HOUSE 2", "OSO9", "") I'm assuming that OSO1 and OSO9 are text strings, if they are fields, leave off the quotes. I like to add the carriage returns to space out the calculation and make it easier to read. When using the Case() statement, remember that the tests are performed in order. -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8552 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now