A report I receive has some "bad" pieces of data that are really a subcategory of a bigger category. On the report it should be showing the field as tire (for example) but instead I would see one instance of "Firestone." I really do not care about Firestone as it should be grouped under the tire category. Is there a command I can run in Access to take "Firestone", "Goodyear" and "Michellen" and group them under tire?

Thank you!