I want to add a field called "Grouping Description" to a query that will detail the meaning of something called a grouping code (basically tags). The reason I want to do this in the query is because it contains only the distinct grouping codes so adding the description there would be much easier than trying to add the same descriptions over an over in the table data it pulls from (as the grouping codes are not unique and are attached to many different items). I've tried using this "Grouping Description: ([Grouping Description])" as the field name but the prompt that comes up adds the value I enter to all of the grouping codes. Basically, is there a way to do this that I'm missing? I'll include some images for reference.