CODEWITHSUNDEEP
vbams-access
Cindy
Cindy

Reputation: 3

Is there a way in Access reports to show only one of each item but all of its attributes?

I'm not sure exactly how to explain it but basically I want to go from something like this

enter image description here

to this

enter image description here

Upvotes: 0

Views: 192

Answers (1)

Lee Mac
Lee Mac

Reputation: 16025

The easiest method would be to create a report from your query, add a group to the report grouping by the Food field, and place the Food field within the group header.

Upvotes: 1

Related Questions