Wondering if anyone has an idea for my situation. I have 20 fields on my custom form called Brand 1, Brand 2, ...Brand 20. They have the same options to select from in each of the fields. Brand list ex: Bear, Tiger, Monkey, Wolf and Dog. How can I...

[PamGr1]

get a report that sums by Brand (Bear, Tiger, Monkey...)? It would be easy if they all shared the same field called Brand, but they don't. I don't care about the Brand 1, Brand 2....I just need to know the number of Bear, Tiger, Monkey. Does that make sense?