Shading duplicates?

[Jennacat]

I was wondering, is there a way to shade duplicates in a query? I have a database that contains product formulations. When queried, all the products are listed along with their components like this:

Product A Methanol 67%
Product A Water 23%
Product A IPA 10%
Product B Water 50%
Product B P123 50%
Product C P45 26%
Product C Water 40%
Product C Q897 20%
Product C T79 14

and so on. Is there a way to shade so that it is easier to see the product grouping? Ex. All Product A shaded, Product C shaded, etc. Would I have to do a make table query? If so, can I shade? Thanks for your help!

 

[boblarson]

If this is a query, then make it easy on yourself to view the data - create a report from it. Reports do that sort of thing well. You can do a lot for the visual presentation that way. Queries are not built for presentation.

 

[boblarson]

In a report you can group by product so then the name will show up once and give you natural breaks, etc.

 

[Jennacat]

Thanks

Thank you so much! I don't know why I didn't think of that. It's been a long day.