MS Access Reports: How do I group by two fields on the same level (OR?)

Question

I have a database of music manuscripts that looks like the below diagram. A 'Source item' belongs to a certain manuscript (source). A source item is then categorized as EITHER a 'Section' of a 'Piece' OR an 'Extract' of a 'Section'. This categorization is done by filling in either the Section ID or Extract ID in respective fields in the Source item table.

My problem: I am creating a report in MS Access. I want to group the Source items which are Sections under a Section group, but then also group the Source items that are Extracts under the same group. At this moment I have only these levels:

Group on Piece title -> group on Section text_incipit -> group on Source item text incipit

I would like to do something like this:

Group on Piece title -> group on Section text_incipit -> group on Source item text incipit OR group on Extract text incipit.

Is there a way of grouping with an OR? Or can this be achieved some other way?

Zen · Accepted Answer · 2025-06-10 09:36:57Z

0

Add to the data source of the report an additional field where you define the value based on your grouping criteria. Use this field than for grouping of the report.

answered Jun 10 at 9:36

Zen

2772 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS Access Reports: How do I group by two fields on the same level (OR?)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related