DataPro Posted September 11, 2004 Posted September 11, 2004 In all of the examples I find with the case statement, you have one test and get one result. I need to changed the value of two fields per test. For instance: If the Month field is = "JAN", I want to assign a time that a location opens and closes (two separate fields). I have lots of fields that need to be assigned, so I don't want to break this up into multiple tests.
The Shadow Posted September 11, 2004 Posted September 11, 2004 Add another field, type text, that holds the result of the Case() with two results, ie:
DataPro Posted September 12, 2004 Author Posted September 12, 2004 Didn't think of that. Good idea! Thanks! Paul
Recommended Posts
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