How would you do this in your query if the value I need to put into a percentage is text. Ex: I want to make a chart and knowing if the item sold is a toy, a tool or other. I want to have the percentage from this category and the query would have to check the category field and make a percentage from it for the 3 categories.