Search results

Yes, I can agree with you, but what I need is that after "Case Else", it'll return [Price] True Value ( Original Value ) let's say that the [Price] is 26500, so I want it to return 26500. I don't know what should I do after I put in "Case Else" so I left it be. I've searched some information...

That's something new to learn about using Single and Double Number Formats, now that Partition() function is really new to me, and never did I see a function like this has been used by people on the Internet. Can you give me an Example for how to use it ? Thank you very much ..

I've tried this step, it's also didn't meet my expectation .. or maybe I did the wrong step ? I made a table name "test" CoNum Num 10 10 20 20 50 50 100 100 --- --- 20000 20000 and then, in the form, I made a...

First this problem started when I wanted to use Switch Function in a Query field like this one Amount: Switch([Price]<=10,10,[Price]<=20,20,[Price]<=50,50,[Price]<=100,100,[Price]<=200,200,[Price]<=300,300...