Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i have a table which have only 2 columns
1-items
2-price
and i want create group depend on price value
So that if the price is greater than zero, it goes to the sales group, and if it is smaller than zero, it goes to the purchases group in the same table, knowing that the table does not contain the type of purchases and sales and i prefer there will be column which describe if this purchases or sales and i want it exactly like this pic


https://i.ibb.co/BKsMKkD/image.jpg[^]

What I have tried:

i have try to create a group but i don't know how will be expression
Posted
Updated 23-Feb-20 1:42am

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900