markhardee Posted April 10, 2001 Share Posted April 10, 2001 This probably SOOOOO easy.. but.. I have the need to have the database make a few decisions. So, I figure CASE is the way. However, I can get it work when there are two tests, results in the Calc but no more. In particular... Case(Shipped VIA="PYRAMID", MATCH SHIP CODE::Courier Charge, Shipped VIA="RUSH 4 U", MATCH SHIP CODE::Courier Charge, Shipped VIA="FEDEX", MATCH SHIP CODE::Courier Charge,"0") Shipped Via is a pull down value list MATCH SHIP CODE relates to Customers database the default result occurs when the user enters Pickup (or anything other than PYRAMID or RUSH 4 U) in the Shipped VIA field. The last test for FEDEX is always ignored... Is there a limit to the number of tests and result pairs that CASE can handle? Thanks a diaperload in advance.... null Link to comment Share on other sites More sharing options...
markhardee Posted April 10, 2001 Author Share Posted April 10, 2001 BEFORE anyone hurts their head working on this... (red-faced) you must actually *HAVE* some data in the field for it to return a result! I was testing with a record that had no value in the fedex field.. wimpering away..... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8437 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