markhardee Posted April 10, 2001 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
markhardee Posted April 10, 2001 Author 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.....
Recommended Posts
This topic is 8735 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