Forum Discussion
Solved
IIF Statement for a 1:M
Hi, First time poster: My data table has a 1:M relationship and I want to qry the highest level of 'color' Red is Highest; Green Lowest ID Color 1 Red 1 Green 1 Yel...
you create a table (on demo ColorT) and input the colors in Ascending orders.
then create a Query (FinalQuery) that will output your result.
see the attached demo
I think the result is different:
1 Red
2 Yellow
3 Yellow
4 Red
1 Red
2 Yellow
3 Yellow
4 Red