I want to create a report or a query to accomplish this: Let's say we have field called color. If the color is green, it is assigned as 3 points. Yellow is 2 points. Red is 1 point. Now I want to get a list of contacts with their names and the points based on the color they picked. Something looks like: Name Points xxx 2 xxx 3
I want to create a report or a query to accomplish this: Let's say we have field called color. If the color is green, it is assigned as 3 points. Yellow is 2 points. Red is 1 point. Now I want to get a list of contacts with their names and the points based on the color they picked. Something looks like: Name Points xxx 2 xxx 3
